, SQL . SQL. , , . , , .
SQL SELECT SQL, , SELECT . () SELECT .., .. . , SELECT SQL.
SELECT :
SELECT:
* , ;
_1, _2 , . , ;
_1, _2 , ;
, ;
__ , , , .
:
ALL . SQL , ALL;
DISTINCT , . , , SELECT, ;
DISTINCTROW , , ;
TOP , , ORDER BY;
FROM , , SELECT;
WHERE . (= | <> | < | <= | > | >=) WHERE BETWEEN (), LIKE ( ), IN (), IS NULL ( ) EXISTS (), NOT (). , :
|
|
AND AND ;
OR OR ;
AND NOT ;
OR NOT , .
AND OR ( AND OR). WHERE , .
, , .
GROUP BY , , , SELECT SQL- SUM (), COUNT (), MIN ( ), MAX ( ) AVG ( ).
HAVING , .
ORDER BY .