20,359
社区成员
发帖
与我相关
我的任务
分享
select addDay,status from table where status < 6 order by addDay desc,status asc
union all
select addDay,status from table where status >= 6 order by addDay desc,status asc
order by case when status<6 then addDay else 1 end desc,status asc
order by case when status<6 then addDay else 1 end desc,addDaydesc,status asc
select * from tbl_name order by status>=6, addDay desc, status asc