column1用升序,column2降序,sql该这样写
ORDER BY column1, column2 DESC
也可以这样写,更清楚:
ORDER BY column1 ASC, column2 DESC
如果都用降序,必须用两个desc
ORDER BY column1 DESC, column2 DESC
ORDER BY column1, column2 DESC
也可以这样写,更清楚:
ORDER BY column1 ASC, column2 DESC
如果都用降序,必须用两个desc
ORDER BY column1 DESC, column2 DESC