Підзапити

Not IN

select adressa, pib from pracivnuk WHERE adressa like 'm%' and pib not in

(select pib from pracivnuk Where pib like 't%');

ALL

select pib,zarplata from pracivnuk WHERE zarplata-1000> all

(select cina*6 from zakaz);

ANY

select pib,telefon from pracivnuk WHERE telefon *2< any

(select telefon from sklad);

EXISTS

select pib,zarplata from pracivnuk WHERE pib like 'p%' and exists

(select pib from pracivnuk where staj>4);

NOTEXISTS

select adressa,telefon from sklad WHERE adressa like 'K%' and not exists

(select vuno from sklad where vuno>100);

INSERT

insert into prof (id_profesii,nazva)

select zarplata,adressa from pracivnuk where zarplata in// moze butu

(select zarplata from pracivnuk where zarplata <2500);

DELETE

delete from sklad where telefon > any

(select telefon from pracivnuk);

UPDATE

update pracivnuk set zarplata=zarplata+500 where staj >3 and zarplata > all

(select cina*6 from zakaz);

Дата добавления: 2015-07-11