比如
select * from userInfo where userId in (1,2,5,4,3)
我想让结果按照userId等于1,2,5,4,3的情况输出
------解决方案--------------------------------------------------------
这种需求比较特别
可以试试
select * from userInfo where userId in (1,2,5,4,3)
order by decode( userId,1,1,2,2,5,3,4,4,3,5,userId )