sqlserver 2005 分页查询支持

wayfoon

类似oracle中的查询分页，也提供了查询分页 sqlserver 2005
oracle：
select *
  from (select c.*, rownum rn from content c where rownum  <= 5)
 where rn >= 1
  
sqlserver 2005：
SELECT *
FROM (select ROW_NUMBER() Over(order by folderid) as rowNum, *
from t_mkt_folder) as t
where rowNum> 0 and rowNum<10