WHERE a.cnum=b.cnum
AND b.city ='San_Jose');
San Jose, ; . , < ANY , > ANY .
11 ANY
, - ( 13):
SELECT *
FROM Orders
WHERE amt<(SELECT MAX (amt)
FROM Orders a, Customers b
WHERE a.cnum=b.cnum
AND b.city='San_Jose');
12 ANY
all
ALL, , . , , Rome, 13:
SELECT *
FROM Customers
WHERE rating>ALL
(SELECT rating
FROM Customers
WHERE city='Rome');
13 ALL
. . - Giovanni (200). , 200.
ANY, EXISTS - ( 14):
SELECT *
FROM Customers outers
WHERE NOT EXISTS
(SELECT *
FROM Customers inners
WHERE outers.rating<=inners.rating
AND inners.city = 'Rome');
14 EXISTS ALL
ALL , " " , , . :
SELECT *
FROM Customers
WHERE rating = ALL
(SELECT rating
FROM Customers
WHERE city='San_Jose');
, , c , . - San Jose . , :
SELECT *
FROM Customers
WHERE rating =
(SELECT DISTINCT rating
FROM Customers
WHERE city='San Jose');
, , ALL . , . , , . , ALL , " < > ". SQL - , - . , , , . SQL, - < > ALL - " " . , , . , ( 16):
|
|
SELECT *
FROM Customers
WHERE rating<>ALL
(SELECT rating
FROM Customers
WHERE city='San Jose');
cnum | cname | city | rating | snum |
Hoffman | London | |||
Clemens | London | |||
Pereira | Rome |
16 ALL < >
San Jose. : 200 ( Liu) 300 ( Cisneros). , , , - 100. NOT IN:
SELECT*
FROM Customers
WHERE rating NOT IN
(SELECT rating
FROM Customers
WHERE city='San Jose');
ANY:
SELECT *
FROM Customers
WHERE NOT rating = ANY
(SELECT rating
FROM Customers
WHERE city ='San Jose');
.