直接select in的话,sql默认会帮你排序,这个功能,有时很方便,但如果我们不需要它自动排序,就有点麻烦了
ACCESS中可以这样:
select*fromtablewhere id in(10,6,9,20)orderby Instr("10,6,9,20",","+cstr(id))desc
SQL中要这样:
select*fromtablewhere id in(10,6,9,20)orderbycharindex(','+cast(idasnvarchar(20))+',' ,',10,6,9,20,')desc