oracle按照in的顺序进行排序
select * from table_name where id in (1,3,7)order by case id when 1 then 1 when 3 then 2 when 7 then 3 end;
本文共 227 字，大约阅读时间需要 1 分钟。
oracle按照in的顺序进行排序
select * from table_name where id in (1,3,7)order by case id when 1 then 1 when 3 then 2 when 7 then 3 end;
转载于:https://www.cnblogs.com/gavinYang/p/4149905.html