oracle----笛卡尔集---多表查询---内链--外链---子查询

笛卡尔集



--多表查询+过滤
select
sc.*
stu.*
c.*
from score ,student,course c
--乘了在解决条件
where sc.student=stu.id and sc.courseid=c.id
--统计
group by
--升序
order by
----------------------内连接
select
sc.*
from score sc
--把外部表加进来乘(乘时就把条件解决)
inner join student s on sc.studentid=s.id
----------------------外链接
select
sc.*
from score sc
--把外部表加进来乘(乘时就把条件解决)out--补额外的数据
left outer join student s on sc.studentid=s.id

---------------------------------------------------
--子查询
--1.select
--在查询中的表中再次查询
select e.*,(select d.dname from dept d where d.deptno=e.deptno) dname from emp e;
--2.where
select e.* from emp e where e.deptno=(select deptno from dept where dname='SALES');
--3.from
select*from(select e.*,rownum num from emp e where rownum<=10) temp
where num>5