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 e
union // 两表连接，列数要相同
select id,name from d;

select id from e
union
select id from d;

select id from e
intersect   // 返回都匹配的数据
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’);