The ORDER BY keyword is used to sort the result.
关键字ORDER BY可用来整理结果

Sort the Rows
将几条记录做整理

The ORDER BY clause is used to sort the rows.
ORDER BY 子句用来整理记录行

Orders:
定单数据库表：

举例

To display the companies in alphabetical order:
显示为按字母顺序排列：

SELECT Company, OrderNumber FROM Orders
ORDER BY Company

结果:

举例

To display the companies in alphabetical order AND the ordernumbers in numerical order:
显示的结果按字母排序以及数字大小来排列：

SELECT Company, OrderNumber FROM Orders
ORDER BY Company, OrderNumber

结果:

举例

To display the companies in reverse alphabetical order:
显示出来的公司名称按字母反向排列：

SELECT Company, OrderNumber FROM Orders
ORDER BY Company DESC

结果:

举例

To display the companies in reverse alphabetical order AND the ordernumbers in numerical order:
显示的公司名称以及定单数都以反序排列

SELECT Company, OrderNumber FROM Orders
ORDER BY Company DESC, OrderNumber ASC

结果:

SQL 技能测试 SQL 与 & OR

评论 (0) All