Filter
Top Products
[Figure: Example of specifying a subquery in a comparison predicate to retrieve data]
Example 11:
In this example, the maximum value for ITMNO is fetched from the STOCK table, and the PRODNO
rows for that value are deleted from the ORDER table.
DELETE FROM STOCKS.ORDER
WHERE PRODNO = (SELECT MAX (ITMNO) FROM STOCKS. STOCK)
92