让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,')