MySQL排序查询示例

按表达式排序

案例3：按年薪的高低显示员工的信息和年薪

SELECT *, salary * 12*(1+ IFNULL(commission_pct, 0)) AS 年薪
FROM employees;
ORDER BY salary * 12*(1+ IFNULL(commission_pct, 0)) DESC;

按别名排序

案例4：按年薪的高低显示员工的信息和年薪

SELECT *, salary * 12*(1+ IFNULL(commission_pct, 0)) AS 年薪
FROM employees;
ORDER BY 年薪 DESC;

按函数排序

案例5：按姓名的长度显示姓名和工资

SELECT LENGTH(last_name) 字节长度, last_name, salary
FROM employees
ORDER BY LENGTH(last_name) DESC;

按多个字段排序

案例6：查询员工信息，要求先按工资升序，再按员工编号降序

SELECT *
FROM employees
ORDER BY salary ASC, employee_id DESC;