SQL ORDER BY
ORDER BY 按一列或多列排序，ASC 升序（默认）、DESC 降序。
Key PointsSQL,ORDER BY,排序,ASC,DESC
讲解
ORDER BY 按一列或多列排序，ASC 升序（默认）、DESC 降序。
示例
SQL
SELECT * FROM Websites
ORDER BY alexa DESC;Output
id name url alexa country
-- --------- ------------------------- ----- -------
3 菜鸟教程 https://www.runoob.com/ 4689 CN
4 微博 https://weibo.com/ 20 CN
2 淘宝 https://www.taobao.com/ 13 CN
5 Facebook https://www.facebook.com/ 3 US
1 Google https://www.google.com/ 1 US讲解
ORDER BY 按一列或多列排序，ASC 升序（默认）、DESC 降序。
示例
SQL
SELECT * FROM Websites
ORDER BY alexa DESC;Output
id name url alexa country
-- --------- ------------------------- ----- -------
3 菜鸟教程 https://www.runoob.com/ 4689 CN
4 微博 https://weibo.com/ 20 CN
2 淘宝 https://www.taobao.com/ 13 CN
5 Facebook https://www.facebook.com/ 3 US
1 Google https://www.google.com/ 1 US