一个有关order by charindex的问题
select * from table1 where id in (183,200,211,145,89,139,83,45) order by charindex(ltrim(id),'183,200,211,145,89,139,83,45')

每次查询出来的结果都变成了183,83,200,211,145,45,89,139 后两位相同的总是显示到一起去了,不知道为什么,请各位高手帮忙看看,数据可能会上万条.

[解决办法]

SQL code

select * from table1 where id in (183,200,211,145,89,139,83,45) order bycharindex(','+ltrim(id)+',',',183,200,211,145,89,139,83,45,')