--ORDER BY 默认排序方式为升序ASC:SELECT * FROM [TABLE_NAME] ORDER BY [COLUMN_NAME] ESC;
--升序DESC:SELECT * FROM [TABLE_NAME] ORDER BY [COLUMN_NAME] DESC;
--ORDER BY 默认排序方式为升序ASC:SELECT * FROM [TABLE_NAME] ORDER BY [COLUMN_NAME] ESC;
--升序DESC:SELECT * FROM [TABLE_NAME] ORDER BY [COLUMN_NAME] DESC;
转载于:https://www.cnblogs.com/tanjiyuan/p/11261289.html