（39-42/178）排序查询order by

#进阶3 排序查询,asc desc
/*
order by
1. asc and desc
2. 子句中可以支持多个字段、表达式、函数、别名
3. 字句一般放在查询语句的最后，limit除外

*/
#案例1

SELECT * FROM employees
ORDER BY employee_id DESC;

#案例2

SELECT *
FROM employees
WHERE department_id>=90
ORDER BY hiredate DESC;

#案例3：按年薪的高低显示员工的信息和年薪【按表达式排序】

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

#案例4：按照姓名长度显示姓名、工资【按函数排序】

SELECT LENGTH(CONCAT(last_name,first_name)),CONCAT(first_name,SPACE(1),last_name) 姓名,salary
FROM employees
ORDER BY LENGTH(CONCAT(last_name,first_name))DESC;

#案例5：按照工资、编号排序

SELECT *
FROM employees
ORDER BY salary DESC,employee_id;

#作业1、2、3

SELECT last_name,department_id,salary*12*(1+commission_pct) 年薪
FROM employees
ORDER BY 年薪 DESC,last_name ASC;

SELECT last_name,salary*(1+commission_pct) 工资
FROM employees
WHERE salary NOT BETWEEN 8000 AND 17000
ORDER BY 工资 DESC;

SELECT *
FROM employees
WHERE email LIKE '%e%'
ORDER BY LENGTH(email) DESC,department_id ASC;