The predicates used in DELETE statements, like those in SELECT and UPDATE, use one or more expressions (for example, location ='Bahrain'). This will test whether TRUE, FALSE, or if NULLs exist, UNKNOWN for each row based on the values within that row. Each row for which the predicate is TRUE is deleted.