(1)ORDER BY column1,column2;
表示:column1和column2都是升序
(2)ORDER BY column1,column2 DESC;
表示:column1 升序,column2是降序;
(3)ORDER BY column1 DESC,column2;
表示:column1降序,column2升序
(4)ORDER BY column1 DESC,column2 DESC;
表示:column1和column2都是降序。
转载链接:https://blog.csdn.net/lixiaogang_theanswer/article/details/79721485