求一句Select语句的写法 没分了，感谢帮助

[Initial_R]

rs.Open"SELECT * FROM Dome WHERE ID in(1,5,7,8,12,24) ORDER BY ID in(1,5,7,8,12,24) ASC",conn,1,1

如上这种形式，请教正确的排序写法该是怎样的？

[intereye]

rs.Open"SELECT * FROM Dome WHERE ID in(1,5,7,8,12,24) ORDER BY ID ASC",conn,1,1

不就是升序吗?

[Initial_R]

如果WHERE ID in(3,5,1,8,7,22) 这样呢？

[deninghe]

楼主想实现什么 说清楚嘛

[邪V风]

rs.Open"SELECT * FROM Dome WHERE ID in(3,5,1,8,7,22) ORDER BY ID ASC",conn,1,1
一样可以实现啊
本来就是按照ID进行排序的

[wgybb]

rs.Open"SELECT * FROM Dome WHERE ID in(1,5,7,8,12,24) ORDER BY ID ASC",conn,1,1
就是这样呀

[Initial_R]

我想按照 WHERE ID in(...) ←括号里的顺序进行排序

[mysqlaping]

一条一条拿吧。。。。

[zzhhll003]

路过,关注...

[zzhhll003]

建议楼主类似的程序还不如用数组做,或者设为不同的表,用表间嵌套做.

[bob_wang526]

up

[roseqiu1]

把(1,5,7,8,12,24)放在数组里,然后用循环一条一条的取吧

[jiangsh100]

脱裤子放屁啦，按ID的大小排了不在乎ID怎么放啊

[enterala]

SELECT * FROM Dome WHERE ID in(1,5,7,8,12,24) ORDER BY ID ASC

[iasky]

SELECT * FROM Dome WHERE ID in(1,5,7,8,12,24) ORDER BY ID ASC