If a condition is specified for data deletion, all rows that satisfy the condition are deleted. To delete by specifying a condition, the WHERE clause must be specified in the DELETE statement.

The following figure shows, as an example of deletion with a condition specified, the procedure for deleting from the stock table only the items whose product name is SKIRT.

Figure 2-18 Example of deletion with a condition specified