重复最多的记录，提示超时

[piperzero]

Set rs3 = Server.CreateObject("ADODB.Recordset")
sql3="select count(articleid) as cnumber,articleid from faq group by articleid order by cnumber desc"
rs3.open sql3,conn,1,1
while not rs3.eof
response.Write(rs3("cnumber"))
rs3.movenext
wend
SQL语句是正确的，但是无法运行，提示超时。

[jykgps]

sql 语句的问题吧 "select count(articleid) as cnumber,articleid from faq group by articleid order by cnumber desc"

count(articleid) as cnumber,articleid 好像不能这样写吧,

[xiaolei1982]

ms单看这个没有错误，是这的问题吗？

[liangjianshi]

看起来没问题啊

[AMinfo]

增加一个i做为变量判断，假设有1万条记录的话，建议楼主换一下代码试试
response.buffer=true
session.timeout=60
Set rs3 = Server.CreateObject("ADODB.Recordset")
sql3="select count(articleid) as cnumber,articleid from faq group by articleid order by cnumber desc"
rs3.open sql3,conn,1,1
i=1
do while not rs3.eof and (i<10000)
response.Write(rs3("cnumber"))
rs3.movenext
i=i+1
loop

[toury]

SQL语句有问题
换成:
sql3="select count(articleid) as cnumber,articleid from faq group by articleid order by count(articleid) desc"

[piperzero]

语句是没问题的，MSSQL支持，我的数据库是ACCESS，不支持，晕死了。