分页查询数据（收集）

. 分页查询数据 

--查询到行的结果 

select * from(  

select ID,DocClassName,DocClassDesc, ROW_NUMBER() OVER(order by ID) as row from Sys_DocClass  

) a  

where row between 20 and 30