升序用 asc,降序用 desc
语法:
//升序排(默认排序规则)
select * from emp order by num asc;
//降序排
select * from emp order by num desc;
//按照num的降序排列,当num相同的时候再按照num2的升序排列。
select * from emp order by num desc,num2 asc;
SQL排序
最新推荐文章于 2022-01-04 17:30:45 发布
升序用 asc,降序用 desc
语法:
//升序排(默认排序规则)
select * from emp order by num asc;
//降序排
select * from emp order by num desc;
//按照num的降序排列,当num相同的时候再按照num2的升序排列。
select * from emp order by num desc,num2 asc;