home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The World of Computer Software
/
World_Of_Computer_Software-02-385-Vol-1of3.iso
/
q
/
quasrsql.zip
/
QUERY16.SQL
< prev
next >
Wrap
Text File
|
1991-10-26
|
191b
|
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;