#1. 查询员工的姓名和部门号和年薪,按年薪降序,按姓名升序显示
SELECT last_name,department_id,(salary * (1 + IFNULL(commission_pct,0))) * 12 annual_sal
FROM employees
ORDER BY annual_sal 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 salary,last_name,email,department_id
FROM employees
WHERE last_name LIKE '%e%'
-- WHERE last_name REGEXP '[e]'
ORDER BY length(email) desc,department_id asc;
MySQL_尚硅谷第五章排序与分页练习题
最新推荐文章于 2024-07-25 16:06:56 发布