-



         

- 5


select _

from

where = AND =5.

, - . , - , , select :

select _

from

where _ is in

(select

from

where _ = ).

is in . is not in ( ), contains - , does not contains - . A contains » ( ) , is in ( ). select, from, where , :

order by <> asc -

(asc) (desc)

;

group by <1> - ;

having set <2>

minus - ( ).

select, SQL , (update), (insert) (delete). , 2- ,

update

set Kypc=3

where Kypc=2.

.. 5 15 1996 . ..,

insert inio :

< .., , 5,15/01/96, ..>.

insert ( ) , , , select - . delete . ,

delete

where =2

, 2 ( ).

, count (), sum (), avg (), max min.

, : select count (*) from .