.


:




:

































 

 

 

 


SELECT , , ,




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.

, :





:


: 2015-11-05; !; : 405 |


:

:

, .
==> ...

847 - | 684 -


© 2015-2024 lektsii.org - -

: 0.024 .