use pubs select top 10 * from (select top 20 * from dbo.authors order by au_id) as table1 order by au_id desc截取11~20 的数据
exec('SELECT Top '+cast(@PageSize as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@PageSize* @Pagei as varchar)+' SortField from T )')
直接调用SQL语句就可以了
rs.move n for i=n to n+10 response.write rs(0) rs.movenext i=i+1 next
select top 10 * from
(select top 20 * from dbo.authors order by au_id) as table1
order by au_id desc截取11~20 的数据
for i=n to n+10
response.write rs(0)
rs.movenext
i=i+1
next