[分享]排序与分页习题

2024-04-03 13:21:25

298

SELECT last_name,department_id,salary * 12 year_salary
FROM employees
ORDER BY year_salary DESC,last_name ASC;

SELECT last_name,salary
FROM employees
WHERE salary >8000 ORDER BY salary DESC
LIMIT 20,20;

SELECT last_name,email,department_id
FROM employees
where email like '%e%'
ORDER BY salary DESC,department_id ASC;