SQL
:
| () | EXCEL | |
() , . ( , ).
12 ( , ):
0 , .
1 ( ) .
2 , .
3 . , , , .
4 , , , DML ( ).
5 , . , , .
6 , , .
7 , , , .
8 - .
9 - , , .
10 . , .
11 - .
12 (Nonsubversion) , .
: SQL.
SQL
SQL (structured query language ) , , , .
|
|
|
( ):
SELECT [{ALL | DISTINCT}] _
[AS ][,...]
FROM [ONLY | OUTER]
{ [[AS] ] |
[[AS] ]}[,...]
[ [ _ ] JOIN _ ]
[WHERE _ ] [ {AND | OR | NOT} _ [...] ]
[GROUP BY _ { _ |
ROLLUP _ |
CUBE _ |
GROUPING SETS (__) |
() | _, __ }
[HAVING _ ]
[ORDER BY { _ [ASC | DESC]}[,...]]
SQL ( ):
—
Ø
Ø
—
Ø
Ø
Ø
—
Ø ,
, .
: SQL, , . , . , ( ).
