Question

sql 语句中，一个表有两个字段，status和date，如何查询status是2和6的排在前面，剩下的按照date倒序排序

求指教啊~

Answer 1

select case status when 2 then 2 when 6 then 6 else 7 end statusOrder,status,date from 表名 order by 1,2desc

也就是将status操作后给个伪列进行重排

Answer 2

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;

Answer 3

(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)