SQL ( Structured Query Language), .
SELECT - FROM -WHERE ( - - ):
select < >
from <>
Where <>.
, , :
(_, , , , )
, .. , :
select ,
from
where _ = . ..
where . , :
select unique _
from .
unique .
select *
from .
, where, =, <>, >=, <, <=, AND, OR, NOT, . , , "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 .