, . (.. , ). , (.. , , ):
SELECT *
FROM Orders outer
WHERE amt > =
(SELECT AVG (amt)
FROM Orders inner
WHERE inner.cnum = outer.cnum);
SQL, . - , , IN.
() EXISTS
EXISTS() - . "", . , ,
SELECT DISTINCT snum
FROM Customers outer
WHERE EXISTS
(SELECT *
FROM Customers inner
WHERE inner.snum = outer.snum
AND inner.cnum < > outer.cnum);
- (, ), , snum ( ), cnum ( ). DISTINCT, .
EXIST NOT. , ,
SELECT DISTINCT snum
FROM Customers outer
WHERE NOT EXISTS
(SELECT *
FROM Customers inner
WHERE inner.snum = outer.snum
AND inner.cnum < > outer.cnum);
EXISTS - ANY ALL.
ANY
ANY , . - 1, {1, 2, 3}, ANY ( ). , , , , :
SELECT *
FROM Salespeople
WHERE city = ANY
(SELECT city
FROM Customers);
ANY - SOME. SQL , ANY, - SOME. .
ALL
ALL. ANY. ALL , - . - 1, {1, 1, 1}, ALL ( ).
|
|
, , , :
SELECT *
FROM Customers
WHERE rating > ALL
(SELECT rating
FROM Customers
WHERE city = Rome):
ANY ALL EXIST , . - .. , EXIST, ANY ALL
1: , ( ) (ANY) , , , ( ) . , (ALL) , , , .
2: , , ALL , ANY - .