ORDER BY
对查询到的数据进行排序操作。ORDER BY
子句排序SELECT employee_id,last_name,salary
FROM employees
ORDER BY salary DESC;
SELECT employee_id,salary,salary * 12 annual_sal
FROM employees
ORDER BY annual_sal;
SELECT employee_id,salary,salary * 12 annual_sal
FROM employees
WHERE annual_sal > 81600;
WHERE
需要声明在FROM
后,ORDER BY
之前SELECT employee_id,salary,department_id
FROM employees
WHERE department_id IN (50,60,70)
ORDER BY department_id DESC;
SELECT employee_id,salary,department_id
FROM employees
ORDER BY department_id DESC,salary ASC;
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。