三,排序查询
一、语法
select 查询列表
from 表
where 筛选条件
order by 排序列表 【asc}desc】
二、特点
SELECT * FROM employees ORDER BY salary DESC;
SELECT *
FROM employees
WHERE department_id>=90
ORDER BY employee_id DESC;
- 排序列表 支持 单个字段、多个字段、函数、表达式、别名
SELECT *,salary*12*(1+IFNULL(commission_pct,0))
FROM employees
ORDER BY salary*12*(1+IFNULL(commission_pct,0)) DESC;
SELECT *,salary*12*(1+IFNULL(commission_pct,0)) 年薪
FROM employees
ORDER BY 年薪 ASC;
SELECT LENGTH(last_name),last_name
FROM employees
ORDER BY LENGTH(last_name) DESC;
SELECT *
FROM employees
ORDER BY salary DESC,employee_id ASC;
- order by的位置一般放在查询语句的最后(除limit语句之外)
SELECT *
FROM employees
ORDER BY salary DESC,employee_id ASC limit 0,10;
备注:内容主要来源网上学习的内容,加上自己稍加整理。