一张 很简单的表 test
id no 1 a11
2 b22
3 b33
4 b44select * from test where id in( 2,1,3)
我想要搜索出来的结果能根据in里面的ID进行排序
既按照 id
2
1
3知道可以通过以下实现
select * from test where id = 2
union all
select * from test where id = 1
union all
select * from test where id = 3但跪求更简单高效的方法
id no 1 a11
2 b22
3 b33
4 b44select * from test where id in( 2,1,3)
我想要搜索出来的结果能根据in里面的ID进行排序
既按照 id
2
1
3知道可以通过以下实现
select * from test where id = 2
union all
select * from test where id = 1
union all
select * from test where id = 3但跪求更简单高效的方法
select *
from test
where id in( 2,1,3)
order by decode(id,'2',1,'1',2,'3',3)
from test
where id in( 2,1,3)