(1)查询所有雇员,按月薪升序排序【ORDER BY 字段 ASC】
SELECT * FROM emp
ORDER BY sal ASC;
(2)查询所有雇员,按月薪降序排序【ORDER BY 字段 DSC】
SELECT * FROM emp
ORDER BY sal DESC;
(3) 查询所有雇员,按月薪降序排序,如果月薪相同时,按编号升序排序
SELECT * FROM emp
ORDER BY sal DESC,empno ASC;
(1)查询所有雇员,按月薪升序排序【ORDER BY 字段 ASC】
SELECT * FROM emp
ORDER BY sal ASC;
(2)查询所有雇员,按月薪降序排序【ORDER BY 字段 DSC】
SELECT * FROM emp
ORDER BY sal DESC;
(3) 查询所有雇员,按月薪降序排序,如果月薪相同时,按编号升序排序
SELECT * FROM emp
ORDER BY sal DESC,empno ASC;