CBSE Class 12 Informatics Practices
Question 9 of 79
Database Query using SQL — Question 1
Back to all questions 1
Question ABC Associates has over 2000 employees on its roll and deals with customer support services. Help the company to perform associated operations for calculating the salaries (stored in Sal column) of their employees and to perform relevant analysis on the fetched data from the SQL database/table.
How can we retrieve records where salary is between 1000 and 2000?
SELECT * FROM emp
WHERE Sal BETWEEN 1000 AND 2000;OR
SELECT * FROM emp
WHERE Sal >= 1000 AND Sal <= 2000;