#1.查询员工的姓名和部门号和年薪,按年薪降序,按姓名升序显示
SELECT last_name,department_id,salary*12 "ANNUAL SALARY"
FROM employees
ORDER BY "ANNUAL SALARY" DESC,last_name ASC;
#2. 选择工资不在 8000 到 17000 的员工的姓名和工资,按工资降序,显示第21到40位置的数据
SELECT last_name,salary
FROM employees
WHERE salary NOT BETWEEN 8000 AND 17000
ORDER BY salary DESC
LIMIT 20,20;
#3. 查询邮箱中包含 e的员工信息,并先按邮箱的字节数降序,再按部门号升序
SELECT last_name,email,department_id
FROM employees
-- WHERE email LIKE '%e%'
WHERE email REGEXP '[e]'
ORDER BY LENGTH(email) DESC,department_id ASC;
05-28
1447
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-01
513
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-21
1664
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-10
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交