查询结果按指定的顺序排列
select *
from 表
order by (select case sunxun when ‘A’ then 3 when ‘B’ then 1 when ‘C’ then 2 when ‘D’ then 4 end)
查询结果按指定顺序排列
最新推荐文章于 2024-07-04 14:50:50 发布
查询结果按指定的顺序排列
select *
from 表
order by (select case sunxun when ‘A’ then 3 when ‘B’ then 1 when ‘C’ then 2 when ‘D’ then 4 end)