MySQL基础_案例讲解

最新推荐文章于 2021-09-13 22:42:00 发布

blabla赞

最新推荐文章于 2021-09-13 22:42:00 发布

阅读量397

点赞数

文章标签： mysql

本文链接：https://blog.csdn.net/dadati/article/details/107531607

版权

#案例1：查询员工的姓名和部门编号和年薪，按年薪降序，姓名升序。
SELECT    last_name,department_id,salary*12*(1+IFNULL
(commission_pct,0)) FROM  employees ORDER BY salary*12*(1+IFNULL
(commission_pct,0)) DESC ,last_name ASC;

#案例2选择工资不在8000到17000的员工姓名和工资，按工资降序
SELECT  last_name,salary FROM  employees 
WHERE  salary<8000 OR salary>17000 ORDER BY salary DESC; 

SELECT  last_name,salary FROM  employees 
WHERE  salary NOT BETWEEN 8000 AND 17000 ORDER BY salary DESC; 

#案例3查询邮箱中包含e的员工，并先按邮箱的字节数降序，再按部门号升序
SELECT *,LENGTH(email) FROM  employees  WHERE  email LIKE '%e%' 
ORDER BY  LENGTH(email)  DESC,department_id ASC;