You want to delete all records from a table named "Employees" where the salary is below a certain threshold. Which SQL statement should you use for this task?

DELETE FROM Employees WHERE
DROP TABLE Employees
REMOVE FROM Employees WHERE
TRUNCATE TABLE Employees

The correct SQL statement for deleting records from a table based on a condition is "DELETE FROM Employees WHERE." This statement allows you to specify a condition, such as salary being below a certain threshold, and deletes all matching records from the "Employees" table.

Add your answer