select case status when 2 then 2 when 6 then 6 else 7 end statusOrder,status,date from 表名 order by 1,2desc
也就是将status操作后给个伪列进行重排
select status，date from 表 where status=2 or status=6 order by status
UNION select status，date from 表 where status<>2 and status<>6 order by date;
(select* from tb_1 where status in(2,6) order by date)
union
(select * from tb_1 where status not in(2,6) order by date)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024