( ), , , ..
SELECT.
:
SELECT [ ] { * | . * | [ . ] _1
[AS _1 ] [, [ . ] _2 [AS _2 ] [,...]]}
FROM [,...] [IN ]
[WHERE... ]
[GROUP BY... ]
[HAVING... ]
[ORDER BY... ]
SELECT
: ALL, DISTINCT, DISTINCTROW TOP. . , ALL. ALL DISTINCT , DISTINCTROW TOP n , ORDER BY | |
_1, _2 | , . |
FROM | , , SELECT ( ) |
GROUP BY | |
HAVING | , SELECT GROUP BY. GROUP BY, HAVING , , HAVING. |
ORDER BY | , , . |
SELECT :
SELECT FROM
[WHERE ]
[GROUP BY ]
[HAVING...]
[ORDER BY ]
.
SELECT , FROM
SELECT TOP 5 FROM 5
SELECT TOP 5 FROM ORDER BY 5 ,
SELECT DISTINCT _ AS FROM , _
SELECT & & AS , _ AS FROM , _ , ( ).
WHERE :
AND
Or
NOT
LIKE
BETWEEN... AND
|
|
IN
IS Null
SELECT *, , .
SELECT * FROM WHERE _ >= #1/1/83# _ 1.1.1983
SELECT * FROM WHERE _ >= #1/1/83# AND IN (930381, 930481) _ 1.1.1983 930381 930481
SELECT * FROM WHERE _ BETWEEN #1/1/83# AND #1/1/85# AND IN (930381, 930481) _ 1.1.1983 1.1.1985 930381 930481
SELECT * FROM WHERE LIKE AND IN (930381, 930481) 930381 930481