将sjzfbl等于'100.0%'的排在最后,然后根据date字段倒叙排序 order by case when A.sjzfbl='100.0%' then 0 else 1 end desc,A.date desc