SQL 查询第n条到第m条的数据
select * from(select top m-n+1 * from (select top m * from table1 order by id asc) as table2 order by id desc) as table3 order by id
asp.net
select * from(select top m-n+1 * from (select top m * from table1 order by id asc) as table2 order by id desc) as table3 order by id