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