#排序查询
/*
语法:
select
要查询的东西
from
表
where
条件
order by 排序的字段|表达式|函数|别名 【asc|desc】
*/
SELECT * FROM employees;
#1.按单个字段进行排序
#案例1:查询员工的信息,按工资降序
SELECT
*
FROM
employees
ORDER BY
salary ;
#2.按表达式进行排序
#案例2:按年薪进行降序
SELECT
salary 月工资,salary*12*(1+IFNULL(commission_pct,0))
FROM
employees
ORDER BY
salary*12*(1+IFNULL(commission_pct,0)) DESC;
#3.按别名进行排序
SELECT
salary 月工资,salary*12*(1+IFNULL(commission_pct,0)) 年薪
FROM
employees
ORDER BY
年薪 DESC;
#4.按函数排序
SELECT LENGTH(last_name);
SELECT
last_name,LENGTH(last_name)
FROM
employees
ORDER BY
LENGTH(last_name) DESC;
#5.按多个字段排序
#案例:先按工资进行升序,工资一样再按部门编号
SELECT
*
FROM
employees
ORDER BY
salary ,department_id ASC;