MS SQL server 2005中查询某张表从30-40条数据，但主键ID不是连续的

sql语句：

 

select * from (select * ,row_number() over(order by id) as rowid from TableName) t where t.rowid > 30 and t.rowid <40