The DELETE statement

The DELETE-FROM-WHERE statement

-- Deletes a record
DELETE FROM table_name
WHERE condition;

The DELETE-FROM statement

-- Deletes all the records in a table (virtually identical to truncate) 
DELETE FROM table_name;