排序查询

排序查询：SELECT 查询列表 FROM 表 WHERE 筛选条件 ORDER BY 排序列表(ASC/DESC)
AEC/DESC = 升序/降序，默认为升序
ORDER BY 支持单个字段、多个字段、表达式、函数、别名

按单个字段排序

#1. 查询员工信息，要求工资从高到低排序
SELECT *
FROM employees
ORDER BY salary DESC

#2. 查询部门编号大于等于90的员工信息，按入职时间的先后进行排序
SELECT *
FROM employees
WHERE department_id >= 90
ORDER BY hiredate ASC

按表达式 / 别名排序

#3. 按照年薪的高低显示员工的信息和年薪【按表达式排序】
SELECT *,salary*12*(1+IFNULL(commission_pct,0)) AS "年薪"
FROM employees
ORDER BY "年薪" DESC

按函数排序

#4. 按照姓名的长度显示员工的姓名和工资【按函数排序】
SELECT LENGTH(last_name) AS "字节长度",last_name,salary
FROM employees
ORDER BY LENGTH(last_name) DESC

按多个字段排序

#5. 查询员工信息，要求先按工资升序，再按员工编号降序【按多个字段排序】
SELECT *
FROM employees
ORDER BY salary ASC,employee_id DESC