If the WHERE clause includes a predicate, all the rows of the target table for which the predicate is true are deleted. See the Predicates HELP topic for more information on predicates.