查询排序

  1. -- min => max  排序 ASC
  2. SELECT * FROM emp ORDER BY sal;
  4. -- max => min 排序    DESC
  5. SELECT*FROM emp ORDER BY sal DESC;

组合排序

  1. -- 组合排序 排序 职位和薪资
  2. SELECT * FROM emp ORDER BY job,sal;