一个有关order by charindex的有关问题
一个有关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 后两位相同的总是显示到一起去了,不知道为什么,请各位高手帮忙看看,数据可能会上万条.
------解决方案--------------------
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 by
charindex(','+ltrim(id)+',',',183,200,211,145,89,139,83,45,')