DELETE Statement

DELETE removes all rows that satisfy a given condition from a table:

DELETE FROM <table_name>
[WHERE <condition>]

The following example deletes all employees whose first name is "John" and last name is "Smith":

DELETE FROM employees
WHERE fname = "John" and lname = "Smith"