后续指定排序:order by case when name1 = 'CCC' then 1
when name1 = 'BBB' then 2
....
else 99 end,
case when name2 = 'CCC' then 1
when name2 = 'BBB' then 2
....
else 99 end
后续不指定排序:
指定排序:order by case when name1 = 'CCC' then 1
when name1 = 'BBB' then 2
....
else 99 end,name2,name3,name4