使用sql查询表中第m行至n行的数据

对于sqlserver2000,使用如下语句实现:

select * from

(
select *, couts=(select count(*)+1 from table where  id<t1.id) from table t1

) t2

where  couts between m and n

 

对于sqlserver2005,使用如下语句实现:

select * from

(

select  *,couts=row_number()+1 over(order by id) from table

) t

where couts between m and n