, . , , . , , :
SELECT
first.cname,
second.cname,
first.rating
FROM
Students first,
Students second
WHERE
first.rating = second.rating;
SELECT cname rating first, cname second. FROM , first second Students. Students, first, second, , , . , , , .
, - - , - . , - , - . , . - - . , . - - .
, , . , .
SELECT
first.cname,
second.cname,
first.rating
FROM
Students first,
Students second
WHERE
first.rating = second.rating AND
first.cname < second.cname;
. . ? , , , , . JOIN , .
:
SELECT *
FROM Orders
WHERE snum =
(SELECT snum
FROM Salespeople
WHERE sname = 'Motika');
, . , , .
, :
</> <> <>, <> <> </> < > < > < >.
:
|
|
SELECT *
FROM Orders
WHERE amt >
(SELECT AVG (amt)
FROM Orders
WHERE odate = 10/04/1990);
. , , IN:
SELECT *
FROM Orders
WHERE snum IN
(SELECT snum
FROM Salespeople
WHERE city = "LONDON");
:
SELECT onum, amt, odate, cnum, Orders.snum
FROM Orders, Salespeople
WHERE Orders.snum = Salespeople.snum
AND Salespeople.city = "London";
, ,
SELECT :
SELECT *
FROM Customers
WHERE cnum =
(SELECT snum + 1000
FROM Salespeople
WHERE sname = Serres);
HAVING:
SELECT rating, COUNT (DISTINCT cnum)
FROM Customers
GROUP BY rating
HAVING rating >(SELECT AVG (rating)
FROM Customers
WHERE city = " San Jose');