select * from (
select * from account order by num desc,createDate desc
) a order by a.num desc,date(a.createDate)>=‘2021-09-11‘ desc,a.is_sign desc
先按num排序
然后按创建最新时间排序，最新时间是最近七天
然后再按is_sign排序
原文：https://www.cnblogs.com/zhangfangming/p/15310608.html