Mysql学习——排序查询

# 进阶3：排序查询
/*

语法：
	select 查询列表
	from 表
	[where 字句]
	order by 排序列表 [asc 升序/desc 降序]  默认升序
特点：
	asc 升序
	desc 降序
	order by 后面可以跟字段，别名，函数，表达式
	order by 后面可以根据多个字段综合排序
	order by 语句一般是放在查询语句的最后的 (limit 子句除外)
*/
# 常规排序查询
SELECT * 
FROM employees 
WHERE department_id >= 90
ORDER BY salary DESC;

# 按表达式排序
SELECT salary*12*(1+IFNULL(commission_pct,0)) AS '年薪'
FROM employees
ORDER BY '年薪'

# 按函数排序
SELECT LENGTH(last_name) 字节长度,
		 last_name,
		 salary
FROM employees
ORDER BY LENGTH(last_name)

# 先按员工工资排序，再按员工编号排序
SELECT *
FROM employees
ORDER BY salary ASC,
			employee_id DESC