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
Oracle scott 表关系图打开
原文：http://www.cnblogs.com/albertzz1987/p/7906624.html
