?
SQL . , , . , : Motika, snum, . ( 6):
SELECT *
FROM Orders
WHERE snum =
(SELECT snum
FROM Salespeople
WHERE sname = 'Motika');
() , SQL ( ) WHERE. - , sname Motika, snum .
snum = 1004. SQL, , ,
WHERE snum = 1004
1 900,10. | 3 1990 . |
6
. , , . , , ( , snum), . , Motika, WHERE snum = 1004 , . Motika , , , .
,
, .
snum WHERE city = London WHERE sname = Motika, . , .
( ), . , ; . ( ) , . , : .
|
|
, - :
SELECT *
FROM Orders
WHERE snum =
(SELECT snum
FROM Salespeople
WHERE city = Barcelona);
18,69. | 3 1990 . | |||
1 098,16. | 3 1990 . |
Barcelona - Rifkin, snum . - . SQL , Barcelona , , .
DISTINCT
, , DISTINCT . Hoffman (cnum = 2001).
( 7):
SELECT *
FROM Orders
WHERE snum =
(SELECT DISTINCT snum
FROM Orders
WHERE cnum = 2001);
767,19. | 3 1990 . | |||
4 723,00. | 5 1990 . | |||
9 891,88. | 6 1990 . |
7 DISTINCT
snum Hoffman - 1001, snum ( , Hoffman ). , cnum snum. , ( ) snum cnum. DISTINCT . , - .
. cnum - , . . , . , , , . , .