2、查看dept部门表中的所有记录
SQL>selec * from dept;
3、按部门编号升序排列[默认asc为升序]
SQL>select * from dept order by deptno;
再按部门编号降序排列
SQL>select * from dept order by deptno desc;
4、先无序查看emp表中所有记录,再按员工编号升序排列所有员工。
SQL>select empno, ename from emp;
SQL>select empno, ename from emp order by empno asc;
5、将部门编号不为10的所有员工按员工编号升序排列。
SQL>select empno, ename from emp
where deptno<>10
order by empno asc;
6、将所有员工按部门编号升序排列。
SQL>select ename, sal, deptno from emp
order by deptno asc;
7、将所有员工先按部门编号升序排,当部门一样时,再按姓名降序排。
SQL>select ename, sal, deptno from emp
order by deptno asc,ename desc;