sqlserver 2005 分页查询支持

类似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