oracle4 查询

本文主要是介绍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’);

这篇关于oracle4 查询的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---