ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng)/ProfitPress-MegaCDROM2.B6I/WINDOWS/PROGRAM/WINSQL.ZIP/EXAMPLES.ZIP/QUERY16.SQL

Text File | 1991-05-30 | 191 b | 12 lines

create table temp (
  pno       char(6),
  totqty    integer
);

insert into temp (pno, totqty)
  select pno, sum(qty) from sp group by pno;

select * from temp;

drop table temp;