Filter
Top Products
[Figure: Example of specifying a subquery in a comparison predicate to delete data]
Checking whether a value is a null value
Use the NULL predicate to check whether a column value is a null value. The following are examples of specifying the
NULL predicate:
Example 12:
In this example, rows for which WHCODE is a null value are fetched from the STOCK table.
Example 13:
In this example, rows for which WHCODE is not a null value are fetched from the STOCK table.
93