sql转access分页语句。

[「已注销」]

SELECT TOP (@pagesize) id,(select count(commentid) from Comment where commentparentid=id and commenttype=2  ) as sum2,name,author,date,content,Cover_pic,Views_number  FROM dbo.down WHERE id <= ( SELECT ISNULL(MIN(id),0) FROM ( SELECT TOP (@pagesize*(@page-1)+1) id FROM down ORDER BY id Desc ) A ) ORDER BY id Desc

转access 怎么弄？？？ 没用过access

[bdmh]

把pagesize和page当做参数传给sql

:pagesize
:page

[孟子E章]

你还可以直接拼接啊
sql = "SELECT TOP (" + pagesize + ") id,(select ...其他类似

[「已注销」]

报错 提示包含一个保留字节
然后我改成 这样 直接写参数进去
SELECT TOP (10) id,(select count(commentid) from Comment where commentparentid=id and commenttype=2 ) as sum2,name,author,date,content,Cover_pic,Views_number FROM down WHERE id <= ( SELECT ISNULL(MIN(id),0) FROM ( SELECT TOP (10*(10-1)+1) id FROM down ORDER BY id Desc ) A ) ORDER BY id Desc

又报错提示
用于函数参数的个数不对 ISNULL(MIN(id),0) 这里错了 access不能这样用么？

[dalmeeme]

如果数据源数据量小，可以用双top方法；否则用max方法。
sqlStr = String.Format("select top {0} * from 测试 where 学号>(select max(学号) from (select top {1} 学号 from 测试))", pageSize, ((pageIndex - 1) * pageSize));

[「已注销」]

[Quote=引用 4 楼 的回复:]

如果数据源数据量小，可以用双top方法；否则用max方法。
sqlStr = String.Format("select top {0} * from 测试 where 学号>(select max(学号) from (select top {1} 学号 from 测试))", pageSize, ((pageIndex - 1) * pageSize));
[/Quote]
那就用双top好了。。