目录 排序查询语法案例排序用法按表达式排序按函数排序按多个字段排序 排序查询 语法 SELECT 查询列表 FROM 表 WHERE 筛选条件 ORDER BY 排序列表 ASC|DESC 案例 排序用法 //DESC 从高到低 SELECT * FROM employees ORDER BY salary DESC; //ASC 从低到高 SELECT * FROM employees ORDER BY salary ASC; //不写,默认升序(ASC) SELECT * FROM employees ORDER BY salary; 按表达式排序 SELECT * FROM employees WHERE department_id >= 90 ORDER BY hiredate ASC; SELECT *,salary * 12 * (1 + IFNULL(commission_pct,0)) AS 年薪 FROM employees ORDER BY salary * 12 * (1 + IFNULL(commission_pct,0)) DESC; //或者 SELECT *,salary * 12 * (1 + IFNULL(commission_pct,0)) AS 年薪 FROM employees ORDER BY 年薪 DESC; 按函数排序 SELECT LENGTH(last_name) AS 字节长度,last_name,salary FROM employees ORDER BY LENGTH(last_name) DESC; 按多个字段排序 //先按salary排序,相同时按id排序 USE myemployees; SELECT * FROM employees ORDER BY salary ASC,employee_id DESC;