排序查询
语法
SELECT 查询列表
FROM 表
WHERE 筛选条件
ORDER BY 排序列表 ASC|DESC
案例
排序用法
SELECT * FROM employees ORDER BY salary DESC;
SELECT * FROM employees ORDER BY salary 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;
按多个字段排序
USE myemployees;
SELECT * FROM employees
ORDER BY salary ASC,employee_id DESC;