置顶Id号为81的数据,其他数据根据添加时间倒序排列
select * from db1
order by case when id=81 then id end desc ,case when id<>81 then addtime end desc
转载于:https://www.cnblogs.com/princess93/p/3544124.html
置顶Id号为81的数据,其他数据根据添加时间倒序排列
select * from db1
order by case when id=81 then id end desc ,case when id<>81 then addtime end desc
转载于:https://www.cnblogs.com/princess93/p/3544124.html