WHERE clause of DELETE
The WHERE clause of a DELETE statement specifies a condition that restricts which rows are to be deleted. Only the rows for which the condition is true will be deleted.
The WHERE clause is optional. If it is not specified, all the rows in the table or view will be deleted.
Last modified date: 01/29/2015