Oracle scott 表关系图打开

 

 

 

 

select * from emp;

select deptno,job from emp

select deptno,job from emp group by deptno ,job

select deptno,job from emp group by deptno ,job order by deptno