高分求助，在SQLServer2000里，用一条SQL语句实现取查询结果的第n条到第m条记录？

[lovecure]

如：
select a.*,b.* from plm_user as a,plm_permit as b
where a.code=b.usercode

我想取其结果的第10条至第20条，该怎样写？

[txlicenhe]

Select identity(int,1,1) as id,a.*,b.* into #tmp
from plm_user as a,plm_permit as b
where a.code=b.usercode

Select * from #tmp where id between 10 and 20
drop table #tmp

[zjcxc]

你的表有主键吗,有的话就可以用一条语句查出

select top 10 * from (select a.*,b.* from plm_user as a,plm_permit as b
where a.code=b.usercode) a where 主键 not in(select top 10 主键 from (select a.*,b.* from plm_user as a,plm_permit as b
where a.code=b.usercode
)a)

[zjcxc]

如果没有的话,就用临时表才行:

select top 20 myid=identity(int,1,1),* into #tb from(select a.*,b.* from plm_user as a,plm_permit as b
where a.code=b.usercode) a

select * from #tb where between 10 and 20

drop table #tb

[qianguob]

高，学习。

[pengdali]

declare @SQLStr varchar(8000)
set @SQLStr='SELECT Top '+cast(@每页大小 as varchar)+' * FROM 表 WHERE 主键列 NOT IN (SELECT TOP '+cast(@每页大小*@第几页 as varchar)+' 主键列 from 表 )'
exec(@SQLStr)

[lovecure]

终于搞定了，

select top 10 * from plm_permit inner join plm_user on plm_user.code=plm_permit.usercode
where plm_permit.id not in (select top 200 ID from plm_permit)

还是要谢谢大家了！