sql server 2005以上可以使用的分页查询语句

例:

select * from(

select ROW_NUMBER() OVER(order by Id Desc) as rowid,* from news

) as tb

where  tb.rowid between 11 and 20