HAVING , . HAVING, , HAVING. 6, HAVING , SELECT GROUP BY. , . , HAVING , . , , .
, , , , (SUM) , , 2000.00 (MAX) :
Select odate, SUM (amt)
FROM orders a
GROUP BY odate
HAVING SUM (amt) > (SELECT 2000.00 + MAX (amt)
FROM Orders b
WHERE a.odate = b.odate);
MAX , . , , WHERE. GROUP BY HAVING.
, ( ) . , , , .
, DISTINCT . , , . , , , , , .
, , , . , , , , , , , .
SQL . , , , HAVING. , .
SQL. , IN, IN, . , 12, EXISTS.
SQL
1. SELECT, , .
2. , ( ), , . . ? (: , , , ).
(. A .)