More on Set-Comparison Operators

• We’ve already seen IN, EXISTS and UNIQUE. Can also use NOT IN, NOT EXISTS and NOT UNIQUE.

• Also available: op SOME, op ALL, op IN

• Find sailors whose rating is greater than that of some sailor called Horatio:

SELECT *

FROM Sailors S

WHERE S.rating > SOME (SELECT S2.rating

FROM Sailors S2

WHERE S2.sname=‘Horatio’)

Previous slide

Next slide

Back to first slide

View graphic version