读书人

让sql话语不排序按照in语句的顺序返

发布时间: 2012-07-28 12:25:13 作者: rapoo

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

读书人网 >SQL Server

热点推荐