[分享]排序与分页习题
2024-04-03 13:21:25
0
108
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;评论
登录 | 注册