#分页的练习
#查询员工的姓名和部门号和年薪,按年薪降序,按姓名升序显示
SELECT last_name,department_id,salary *12 annual_salary
FROM employees
ORDER BY annual_salary DESC,last_name ASC;
#选择工资不在8000-17000的员工姓名和工资,按工资降序,显示第21到40位置的数据
SELECT last_name,salary
FROM employees
WHERE salary NOT BETWEEN 8000 AND 17000
ORDER BY salary DESC;
LIMIT 20,20;
#查询邮箱中包含e的员工信息,并先按邮箱的字节数降序,再按部门号升序
SELECT employee_id,last_name,email,department_id
FROM employees
#WHERE email LIKE '%e%'
WHERE email REGEXP '[e]'
ORDER BY LENGTH (email) DESC,department_id ASC;
分页的练习
最新推荐文章于 2024-09-30 11:01:45 发布