sql语句order by优先级分等级多次排序、sql语句多字段分优先级排序
表数据为要求:plan_failed_reason字段不为空的在最上面;然后是plan_result字段根据/查分,后面数字比前面大的;最后是其他的数据。sql语句为:SELECT id, plan_result, plan_failed_reason FROM mas_opt_scheme_req ORDER BYCASE WHEN plan_failed_reason != '' THEN 1 ELSE 10 END,CASE WHEN SUBSTRING_.