ORDER BY 后可加2个字段,用英文逗号隔开。当第一个条件相等时,才会用第二个条件去排序。
例:
A用升序, B降序,SQL该这样写
ORDER BY A , B DESC
也可以这样写,更清楚:
ORDER BY A ASC , B DESC
如果都用降序,必须用两个desc
ORDER BY A DESC , B DESC
ORDER BY 后可加2个字段,用英文逗号隔开。当第一个条件相等时,才会用第二个条件去排序。
例:
A用升序, B降序,SQL该这样写
ORDER BY A , B DESC
也可以这样写,更清楚:
ORDER BY A ASC , B DESC
如果都用降序,必须用两个desc
ORDER BY A DESC , B DESC