SELECT - . , , , .. (. 19.9).
19.9. SELECT
: ALL ; DISTINCT , ; DISTINCTROW ; , ORDER BY | |
, | |
1, 2 | , ( ) |
1, 2 | |
FROM | , ( ) |
[WHERE... ] | () |
[GROUP BY... ] | ( 10) , ; (, ..) |
[HAVING... ] | ( GROUP BY...) |
[ORDER BY... ] | , ; . (ASC), (DESC) |
[WITH OWNERACCESS OPTION] | , , |
, , . , , , (), .
SELECT :
SELECT [] { * | .* | [.]1 [, [.]2.[,...]]}
[AS 1 [, 2 [,...]]]
FROM [,...] [IN __]
[WHERE... ]
[GROUP BY... ]
[HAVING... ]
[ORDER BY...]
[WITH OWNERACCESS OPTION]
SELECT . , .
SELECT . SELECT , , .
:
;
;
;
;
SQL.