order by子句

order by子句的語法為：

select column1, sum(column2)

from "list-of-tables"

order by "column-list" [asc | desc];

[ ] = optional

order by是一個可選的子句，它允許你根據指定要order by的列來以上升或者下降的順序來顯示查詢的結果。例如：

asc = ascending order – 這個是缺省的

desc = descending order

下面舉個例子：

select employee_id, dept, name, age, salary

from employee_info

where dept = 'sales'

order by salary;

這條sql語句將從employee_info表中列dept等于'sales'選擇employee_id,、dept、 name、 age和 salary，并且根據他們的salary按升序的順序來列出檢索結果。

如果你想對多列排序的話，那么在列與列之間要加上逗號，比如 ：

select employee_id, dept, name, age, salary

from employee_info

where dept = 'sales'

order by salary, age desc;