ALLBASE/SQL Reference Manual (36216-90216)

Chapter 9 281
Search Conditions
Quantified Predicate
Example
Get supplier numbers for suppliers who supply at least one part in a quantity greater than
every quantity in which supplier S1 supplies a part.
SELECT DISTINCT SP.SNO
FROM SP
WHERE SP.QTY > ALL ( SELECT SP.QTY
FROM SP
WHERE SP.SNO = 'S1')
An alternative, possibly faster form of the query is:
SELECT DISTINCT SP.SNO
FROM SP
WHERE SP.QTY > (SELECT MAX(SP.QTY)
FROM SP
WHERE SP.SNO = 'S1')