FROM ;
10.2. ;
IV.
. . ORDER BY, , . . , DESC.
11. 7: SELECT- .
11.1 SELECT DISTINCT
FROM
ORDER BY ;
11.2. SELECT DISTINCT
FROM
ORDER BY DESC;
11.3. SELECT , ,
FROM
ORDER BY DESC, , ;
11.4. _6_6, _6_7, _6_8.
12. .
13. .
14. .
[ 3 ], [ 7 ], [ 20 ], [ 24 ], [ 25 ].
7
14. SQL
: SQL .
1. SELECT.
2. .
3. WHERE.
4. .
5. BETWEEN.
6. , .
6. ᒺ .
: .
. Access.
1. .
2. Access.
3. , :C:\ \ \ \ ( ).
4. SELECT.
I.
WHERE, . , .
, ᒺ AND OR.
ᒺ AND, , . ᒺ OR , . AND OR ᒺ .
|
|
5. 1: . .2.17.
2.17
1
5.1. г:
SELECT , AS [ ], AS
FROM
WHERE =+
ORDER BY ;
: . , , .
5.2. . 12.
. 12. 1
5.3. _7_1.
6. 2: , 1, .
6.1. г:
SELECT , AS [ ], AS
FROM
WHERE = + AND =
ORDER BY ;
. 13.
. 13. 2
6.3. _7_2.
7. 3: , 05.01.2007 15.01.07 16.01.07 .
. 2.18.
2.18
3
7.1. г: