一、排序 1.排序规则 升序 ASC(默认为升序) 降序 DESC 2.单列排序 # 按照salary从高到低的顺序显示员工信息 SELECT * FROM employees ORDER BY salary DESC; 3.多列排序 # 按照department_id升序、salary降序显示员工信息 SELECT * FROM employees ORDER BY department_id ASC