DELETE Statement Example

This example deletes all records for employees whose title is Trainee. When the FROM clause includes only one table, you do not have to list the table name in the DELETE statement.

DELETE * FROM Employees WHERE Title = 'Trainee';