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