.


:




:

































 

 

 

 


Select Distinct AS INTO




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. г:





:


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


:

:

,
==> ...

1558 - | 1434 -


© 2015-2024 lektsii.org - -

: 0.015 .