#排序与分页
#排序
SELECT * FROM employees;
#从高到低排序 ORDER BY
#升序:ASC (ascend) 降序:DESC (descend)
SELECT employee_id,last_name,salary
FROM employees
ORDER BY salary DESC;
#二级排序
#department_id 降序,salary 升序
SELECT employee_id,salary,department_id
FROM employees
ORDER BY department_id DESC,salary ASC;
简单的排序
最新推荐文章于 2024-07-22 22:50:39 发布