Which of the following SQL statements will delete all the records from the table Students that have the last name "Sample"?
A) REMOVE FROM Courses WHERE LastName = 'Sample'
B) REMOVE WHERE LastName = 'Sample' FROM Courses
C) DELETE FROM Courses WHERE LastName = 'Sample'
D) DELETE WHERE LastName = 'Sample' FROM Courses
E) None of the above

Question

Quizplus · Accepted Answer

The correct SQL statement to delete records from a table based on a condition is the DELETE FROM statement followed by the table name, then the WHERE clause specifying the condition. Option C correctly uses this syntax to delete records from the "Courses" table where the LastName is 'Sample'.

Which of the Following SQL Statements Will Delete All the Records