查询Access,select top 10却得到15行的查询结果,why?
Equn 2004-12-06 12:54:44 SQL语句:
select top 10 title,newsfile,listtitle,id from news where formid in(10,11,35,55,56,57,58,36,59,60,61,62,37,63,64,65,66,38,67,68,69,70,39,71,72,73,74,75,76,40,77,78,79,80,41,81,82,83,12,47,104,105,106,107,108,109,110,48,111,112,113,42,84,85,86,87,88,89,43,90,91,92,93,94,44,95,96,97,98,45,99,100,101,102,103,13,49,114,115,50,116,117,118,51,119,120,121,122,52,123,124,53,125,126,54,127,128,129,130,14,15,131,132,133,134,135,136,137,16,138,139,140,141,142,143,17,144,145,146,147,148,149,18,20,21,19,150,159,160,161,151,156,157,158,152,162,163,164,153,165,166,167,154,168,169,170,155,171,172,173,25,26,27,28,29,30,31,32,33,174,175,176,34,177,178,179,1) and isend=1 order by monthtime desc
查询语句如下:
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
结果:
查询得出15行记录集。
ADO的问题吗?在Access中建立上述查询,执行正确。不知是何道理?
window2000 server+sp4,ado2.8已安装