select * from counter.tb_pac_account_glide_pe where COMPARE_BATCH_NO = "25465789361671273" GROUP BY BIZ_NO ORDER BY (case when COMPARE_FLAG ='I' then '0' when COMPARE_FLAG='L' then '1' when COMPARE_FLAG='W' then '2' when COMPARE_FLAG='U' then '3' else COMPARE_FLAG end) ASC
sql语句按照自定义的顺序排序
最新推荐文章于 2024-08-29 09:54:49 发布
select * from counter.tb_pac_account_glide_pe where COMPARE_BATCH_NO = "25465789361671273" GROUP BY BIZ_NO ORDER BY (case when COMPARE_FLAG ='I' then '0' when COMPARE_FLAG='L' then '1' when COMPARE_FLAG='W' then '2' when COMPARE_FLAG='U' then '3' else COMPARE_FLAG end) ASC