select name
from greatestsORDER BY case when name ='B' then 1 when name ='A' then 2 when name ='D' then 3 when name ='C' then 4 else 5 end本文共 194 字，大约阅读时间需要 1 分钟。
select name
from greatestsORDER BY case when name ='B' then 1 when name ='A' then 2 when name ='D' then 3 when name ='C' then 4 else 5 end转载于:https://www.cnblogs.com/newlangwen/p/10565919.html