让sql话语不排序,按照in语句的顺序返回结果

让sql语句不排序,按照in语句的顺序返回结果oracle写法:??Select * from web_pics where id In (8234030,82

让sql语句不排序,按照in语句的顺序返回结果

oracle写法:

?

?Select * from web_pics where id In (8234030,8234025,8234036) order By instr(',8234030,8234025,8234036,',',' || id || ',' )

?

sqlserver写法:

?

?Select?* From Product Where id in (1,1588,15782,9887,54) ?Order By charindex(','+ id +',', ',1,1588,15782,9887,54,')