FROM
WHERE <=#01/05/2007#
OR ( BETWEEN #01/15/2007# AND #01/16/2007#)
ORDER BY DESC;
: // (//).
. 14.
. 14. 3
7.3. _7_3.
II. ,
, , .
8. 4: 3 . 2.19. .
2.19
4
ʳ | ֳ | ||
8.1. г:
SELECT , AS ʳ, AS ֳ, * AS
FROM
WHERE =3
ORDER BY ;
8.2. . 15.
. 15. 4
: , , , . . , ( SELECT), , . , , .
8.3. _7_4.
9. 5: SELECT- :
SELECT , &\& as
FROM
ORDER BY ;
: _12_5.
10. .
11. .
[ 3 ], [ 7 ], [ 20 ], [ 24 ], [ 25 ].
8
14. SQL
: SQL .
1. SELECT.
2. .
3. SUM.
4. MIN, MAX, AVG.
5. .
: .
. Access.
1. .
2. Access.
3. , :C:\ \ \ \ ( ).
|
|
4. SELECT. , , . 2.20.
2.20
Avg() | |
Min(), Max() | |
Sum() | |
Count (*) Count() |
SELECT ( ), , . .
I.
5. 1: 3.
5.1. г:
SELECT SUM(*) as
FROM
WHERE =3;
5.2. . 16.
.16. 1
: SELECT 䳿 , =3, *, .
.
5.3. _13_1.
6. 2: , 3.
6.1. г:
SELECT MIN() as ֳ̳, AVG() as Cֳ,
MAX() as ֳ
FROM
WHERE =3;
6.2. . 17.
. 17. 2
6.3. _8_2.
II.
, .
GROUP BY, ( ).
, ( ) , .
7. 3: .
7.1. г:
SELECT , SUM(*) as
FROM
GROUP BY ;
. 18.
. 18. 3
7.3. _8_3.
8. 4:
8.1. г:
SELECT , SUM(*) as ,
SUM(*)*0.2 as
FROM
GROUP BY ;
8.2. . 19.
. 19. 4
8.3. _8_4.
9. .
10. .
11. .
[ 3 ], [ 7 ], [ 20 ], [ 24 ], [ 25 ].
9
14. SQL
: SQL .
|
|
1. SELECT.
2. .
3. INNER JOIN.
4. .
: .
. Access.
1. .
2. Access.
3. , :C:\ \ \ \ ( ).
4. SELECT.
I.
. , , .
.
-, , ( , ) . , . .
-, ( , , ).
:
FROM 1 INNER JOIN 2 ON 1.1= 2.2
FROM 1 LEFT JOIN 2 ON 1.1= 2.2
FROM 1 RIGHT JOIN 2 ON 1.1= 2.2
INNER JOIN ᒺ , , .
LEFT JOIN ᒺ , , .
RIGHT JOIN ᒺ , , .
, :
FROM 1 LEFT JOIN 2 ON 1.1= 2.2
:
FROM 2 RIGHT JOIN 1 ON 1.1= 2.2
1.1= 2.2 . . .
5. 1: . . 2.21.
2.21
1
5.1. г:
, . . , , , , , ( +).
. SELECT.
, :