SQL2005: select * from (select top 600 rn=row_number()over(order by 索引列),* from tb) t where rn >=100
--sql 2000 select 501 * from ( select top 600 * from tb order by id ) t order by id descselect * from ( select t.* , px = (select count(1) from tb where id < t.id) + 1 from tb t ) m where px between 100 and 600 --sql 2005 select * from ( select t.* , px = row_number() over(order by id) from tb t ) m where px between 100 and 600
select * from (select top 600 rn=row_number()over(order by 索引列),* from tb) t where rn >=100
select 501 * from
(
select top 600 * from tb order by id
) t
order by id descselect * from
(
select t.* , px = (select count(1) from tb where id < t.id) + 1 from tb t
) m
where px between 100 and 600
--sql 2005
select * from
(
select t.* , px = row_number() over(order by id) from tb t
) m
where px between 100 and 600