Question

请问,在SQLSERVER中,一张表有10000条数据,如何取出第10条至第100条数据?

Answer 1

2005版本前没有Row_Number 可以

select * from tb Where id
in (select top 100 id from tb order by id)
And id not in (select top 10 id from tb order by id)

Answer 2

select * from (select rownum num,要查的字段 from table) where num between 10 and 100

Answer 3

请问楼主，你有什么更好的方法分享吗？