Neoview SQL Reference Manual (R2.3)

EMPNUM FIRST_NAME LAST_NAME SALARY
------ --------------- -------------------- -----------
1 ROGER GREEN 175500.00
23 JERRY HOWARD 137000.10
29 JANE RAYMOND 136000.00
...
343 ALAN TERRY 39500.00
557 BEN HENDERSON 65000.00
568 JESSICA CRINER 39500.00
--- 23 row(s) selected.
• This predicate is true if the part number is equal to any part number with more than five
units in stock:
partnum = ANY (SELECT partnum
FROM sales.odetail
WHERE qty_ordered > 5)
Consider this SELECT statement using the preceding predicate:
SELECT ordernum, partnum, qty_ordered
FROM sales.odetail
WHERE partnum = ANY (SELECT partnum
FROM sales.odetail
WHERE qty_ordered > 5);
The inner query providing the comparison values yields these results:
SELECT partnum
FROM sales.odetail
WHERE qty_ordered > 5;
Part/Num
--------
2403
5100
5103
6301
6500
....
--- 60 row(s) selected.
The SELECT statement using this inner query yields these results. All of the order numbers
listed have part number equal to any part number with more than five total units in
stock—that is, equal to 2403, 5100, 5103, 6301, 6500, and so on:
SELECT ordernum, partnum, qty_ordered
FROM sales.odetail
WHERE partnum = ANY (SELECT partnum
FROM sales.odetail
WHERE qty_ordered > 5);
Order/Num Part/Num Qty/Ord
---------- -------- ----------
100210 244 3
100210 2001 3
100210 2403 6
100210 5100 10
100250 244 4
100250 5103 10
100250 6301 15
100250 6500 10
...... .... ..
--- 71 row(s) selected.
254 SQL Language Elements