Select the suitable option for retrieving all the employees whose salary range is between 40000 and 100000?
Answer options
A
SELECT name, salary FROM employee WHERE salary >= 40000 AND salary <= 100000;
B
SELECT * FROM employee WHERE salary BETWEEN 40001 AND 99999;
C
SELECT * FROM employee WHERE salary > 40000 AND salary < 100000;
D
SELECT name FROM employee WHERE salary = 40000 OR salary = 100000;
Correct answer: SELECT name, salary FROM employee WHERE salary >= 40000 AND salary <= 100000;
Explanation
Using >= and <= correctly captures the inclusive range 40000–100000.