SQL指南-ORDER BY子句
The ORDER BY 关键字用于排序结果
---------------------------------
Sort the Rows
The ORDER BY 子句用于给行排序
Orders:
Company | OrderNumber |
---|---|
Sega | 3412 |
ABC Shop | 5678 |
W3Schools | 2312 |
W3Schools | 6798 |
示例
按字母顺序排列companies:
SELECT Company, OrderNumber FROM Orders ORDER BY Company |
返回结果:
Company | OrderNumber |
---|---|
ABC Shop | 5678 |
Sega | 3412 |
W3Schools | 6798 |
W3Schools | 2312 |
示例
按字母和数字给companies 排序:
SELECT Company, OrderNumber FROM Orders ORDER BY Company, OrderNumber |
返回结果:
Company | OrderNumber |
---|---|
ABC Shop | 5678 |
Sega | 3412 |
W3Schools | 2312 |
W3Schools | 6798 |
示例
按字母反序给companies排序
SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC |
返回结果:
Company | OrderNumber |
---|---|
W3Schools | 6798 |
W3Schools | 2312 |
Sega | 3412 |
ABC Shop | 5678 |
示例
按字母和数字反序给companies排序
SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC |
返回结果
Company | OrderNumber |
---|---|
W3Schools | 2312 |
W3Schools | 6798 |
Sega | 3412 |
ABC Shop | 5678 |