IN ( BETWEEN, LIKE, IS NULL ). , IN , , . IN , SQL . , , IN , ( 9):
SELECT *
FROM Orders
WHERE snum IN
(SELECT snum
FROM Salespeople
WHERE city = LONDON);
767,19. | 3 1990 . | |||
1 900,10. | 3 1990 . | |||
4 723,00. | 5 1990 . | |||
9 891,88. | 6 1990 . |
9 IN
, - , :
SELECT onum, amt, odate, cnum, Orders.snum
FROM Orders, Salespeople
WHERE Orders.snum = Salespeople.snum
AND Salespeople.city = London;
767,19. | 3 1990 . | |||
4 723,00. | 5 1990 . | |||
9 891,88. | 6 1990 . | |||
1 900,10. | 3 1990 . |
, SQL . snum city = London, , . snums=1001 snum=1004. , , snum .
, , - . - , .
, . .
IN, . (=), IN. , IN . . ; , . . , , :
|
|
SELECT onum, amt, odate
FROM Orders
WHERE snum =
(SELECT snum
FROM Orders
WHERE cnum = 2001);
767,19. | 3 1990 . | |
4 723,00. | 5 1990 . | |
9 891,88. | 6 1990 . |
DISTINCT IN (=), :
SELECT onum, amt, odate
FROM Orders
WHERE snum IN
(SELECT snum
FROM Orders
WHERE cnum = 2001);
767,19. | 3 1990 . | |
4 723,00. | 5 1990 . | |
9 891,88. | 6 1990 . |
? IN . , . (=), .
, , . , .
, ( ) , =. IN , , . , :
SELECT comm
FROM Salespeople
WHERE snum IN
(SELECT snum
FROM Customers
WHERE city = London);
, 10, Peel (snum = 1001), . - . - . , IN - .
0,12 |
10 IN
, city , city .
SQL FROM . , . , "city" WHERE Customer.city( city ). FROM , SQL - . , . , , .
|
|