table_name specifies the name of the table from which you want to delete rows.
search_condition is an expression that identifies which rows to delete from the table.
The Where clause determines which rows are to be deleted. Without a Where clause, all rows of the table are deleted, but the table is left intact. See
“Where Clause” for information about the syntax of Where clauses. Where clauses can contain subqueries.
Each Delete statement removes every record that meets the conditions in the Where clause. In this case, every record having the employee ID
E10001 is deleted. Because employee IDs are unique in the employee table, at most, one record is deleted.