Question

Consider the following employee table. Write SQL commands for the question.

EMP CODE	NAME	DESIG	PAY	ALLO WANCE
S1001	Hariharan	Supervisor	29000	12000
P1002	Shaji	Operator	10000	5500
P1003	Prasad	Operator	12000	6500
C1004	Manjima	Clerk	8000	4500
M1005	Ratheesh	Mechanic	20000	7000

To remove the employees who are mechanics.

Answer 1

DELETE FROM Employee WHERE DESIG=’Mechanic’;