1、排序 order by
位置通常在最后的子句
-----------------------------------------------------------
例:按多个列排序
SELECT a,b,c
FROM 表1
ORDER BY a,b
------------------------------------------------------------
从大到小DESC,从小到大ASC
例:降序且多个列排序
SELET a,b,c
FROM 表1
ORDER BY a DESC,b;