OFF ������ �� www.sql-ex.ru

[Grishko Aleks]

ëÔÏ ÎÉÂÕÄØ ÉÚ ÕÞÁÓÔÎÉËÏ× ËÏÎÆÙ ÐÒÏÛÅÌ ÄÏ ËÏÎÃÁ ÚÁÄÁÞÉ ÐÏ DML Ñ ÚÁÓÔÒÑÌ ÎÁ 
10, ÐÒÏ×ÅÒËÁ ÎÁ ËÏÎÔÒÏÌØÎÏÊ ÂÁÚÅ ÎÅ ÐÒÏÈÏÄÉÔ, Á ÆÁÎÔÁÚÉÉ ËÁË ÔÏ ÐÏ ÄÒÕÇÏÍÕ 
ÒÅÛÉÔØ ÎÅÈ×ÁÔÁÅÔ...
íÏÊ ×ÁÒÉÁÎÔ:
insert into PC
select (p.model+max(code)) as code,
       p.model as model,
       max(pp.speed),
       max(pp.ram),
       max(pp.hd),
       max(pp.cd),
       avg(pp.price)
       from product p, pc pp
       where  p.type = 'PC'
        group by p.model
       having
       (p.model not in
       (select  pc.model from pc) )
íÏÖÅÔ ËÔÏ ÐÏÄÓËÁÖÅÔ ËÕÄÙ ÒÙÔØ...
úÁÒÁÎÅÅ ÓÐÁÓÉÂÏ.