ASC：升序，默认

DESC：降序

SELECT employee_id, first_name, salary
FROM employees
ORDER BY salary ASC;

SELECT employee_id, first_name, salary
FROM employees
ORDER BY salary DESC;

---

二级排序

按salary降序，employee_id升序

SELECT employee_id, first_name, salary
FROM employees
ORDER BY salary DESC, employee_id ASC;