oracle4 查询

select sum(price*qty) from books;select pub,sum(price*qty) from books group by pub;select pub,sum(price*qty) from books group by pub having sum(price)>50; select a1.count(a1) from aa group by a1 having count(a1)>1;select * from aa where like ‘a_’;select * from aa where like ‘a%’;select * from e,d where e.id=d.id;select * from e join d on e.id=d.id;select * from e join d on e.id=d.id(+); // 左连接select * from e join d on e.id(+)=d.id; // 右连接 select * from e where id in (select id from d);select * from e where id not in (select id from d where id=e.id AND id=’03’);select * from e where EXISTS (select id from d where id=e.id);select * from e where NOT EXISTS (select id from d where id=e.id);select eid,ename from eunion // 两表连接，列数要相同select id,name from d;select id from eunionselect id from d;select id from eintersect   // 返回都匹配的数据select id from d;insert into e(eid,ename) select id,name from d;//插入多行create table ttt as (select * from e);  // 利用已经存在的表创建新表create table t as (select eid,ename from e where eid=’001’);