一、SQL语句实现单字段降序、升序
select a.* from a order by a.id;
默认情况下,一般是升序;关键字升序是asc,降序为desc;
二、SQL语句实现多字段降序
select a.* from a order by a.id desc,a.num desc;
三、SQL语句实现多字段升序
select a.* from a order by a.id ,a.num;
四、SQL语句实现多字段一升一降
select a.* from a order by a.id ,a.num desc;(默认为升序,可以忽略不写);
注意:order by 后面的字段顺序,先按前者进行排序,如果前者的记录是一样的,则按照后者进行排序;