Question

如何在查询结果中 再用sql语句升序和降序排列

Answer 1

就在原查询语句加升序或降序子句，再查询。

Answer 2

select * from news where typeid=’000501‘ order by typeid asc 升序
select * from news where typeid=’000501‘ order by typeid desc 降序