ORDER BY 语句用于对结果集进行排序:
ORDER BY 语句默认按照升序对记录进行排序。
DESC 关键字按照降序对记录进行排序。
ASC官架子按照升序对记录排序。
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
原表格:
Company | OrderNumber |
---|---|
IBM | 3532 |
W3School | 2356 |
Apple | 4698 |
W3School | 6953 |
以字母顺序显示公司名称:(由小到大排序)
SELECT Company, OrderNumber FROM table ORDER BY Company//order by 按从小到大排序
结果:
Company | OrderNumber |
---|---|
Apple | 4698 |
IBM | 3532 |
W3School | 6953 |
W3School | 2356 |
SELECT Company, OrderNumber FROM tables ORDER BY Company, OrderNumber//公司名称和数字都按从小到大排序
结果:
Company | OrderNumber |
---|---|
Apple | 4698 |
IBM | 3532 |
W3School | 2356 |
W3School | 6953 |
SELECT Company, OrderNumber FROM tables ORDER BY Company DESC
结果:
Company | OrderNumber |
---|---|
W3School | 6953 |
W3School | 2356 |
IBM | 3532 |
Apple | 4698 |
SELECT Company, OrderNumber FROM tables ORDER BY Company DESC, OrderNumber ASC
Company | OrderNumber |
---|---|
W3School | 2356 |
W3School | 6953 |
IBM | 3532 |
Apple | 4698 |