Which SQL statement deletes only those employees whose salary is less than 10000?
Options
-
A.
DELETE FROM employees;
-
B.
DELETE FROM employees WHERE salary < 10000;
-
C.
DROP employees WHERE salary < 10000;
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
DELETE FROM employees WHERE salary < 10000;
Detailed Explanation
- DELETE with WHERE: Removes only records satisfying the specified condition.
- salary < 10000: Selects employees whose salary is below 10000.
- Other employee records remain unchanged.
