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 display all employees whose allowance is between 5000 and 7000.

Answer 1

SELECT FROM Employee WHERE ALLOWANCE BETWEEN 5000 AND 7000;