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.

Figure 2-18 shows an example of deletion with a condition specified. Here, only the items whose product name is SKIRT are deleted from the stock table.

Figure 2-18 Example of deletion with a condition specified