排序查询
语法
select 查询列表
from 表
where 筛选条件
order by 排序列表 (asc or desc,默认升序)
- length() 返回字节长度
- 支持函数排序
- 支持表达式排序,支持别名排序
- 支持多个字段排序,用逗号连接即可
- order by一般放在最后面,除了limit语句
SELECT *
FROM employees
ORDER BY salary ASC, employee_id DESC;
1.查询员工的姓名和部门号和年薪,按年薪降序,按姓名升序
SELECT last_name,department_id,salary12(1+IFNULL(
commission_pct
,0)) AS 年薪
FROM employees
ORDER BY 年薪 DESC, last_name ASC;
2.选择工资不在8000到17000的员工姓名和工资,按工资降序
SELECT last_name,salary
FROM employees
WHERE NOT(salary BETWEEN 8000 AND 17000)
ORDER BY salary DESC;
3.查询邮箱中包含e的员工信息,并先按照邮箱的字节数降序,再按部门号升序
SELECT *,LENGTH(email)
FROM employees
WHERE email LIKE ‘%e%’
ORDER BY LENGTH(email) DESC, department_id ASC;
“花花世界,静守己心”
小徐加油!
----2021.1.28