Rows are DELETEd from the specified table when the condition statement is met.
DELETE all rows: DELETE FROM table;
DELETE one or more rows: DELETE FROM table WHERE conditions;
> It is often convenient to test the WHERE clause with a SELECT statement to make sure the proper rows will be selected before using it in a DELETE.
> A subselect may be used to retrieve values for the WHERE clause.
> A subselect is a SELECT statement as described previously that has been attached to another SQL command.