select * from dept where deptno <>10 order by deptno asc; //(升序排列)
select ename, sal, deptno from emp order by deptno asc, ename desc; //(按照多个字段排序 首先按照deptno升序排列,当detpno相同时,再按照ename的降序排列)
select * from dept where deptno <>10 order by deptno asc; //(升序排列)
select ename, sal, deptno from emp order by deptno asc, ename desc; //(按照多个字段排序 首先按照deptno升序排列,当detpno相同时,再按照ename的降序排列)