分页查询数据（收集）

. 分页查询数据 --查询到行的结果 select * from( select ID,DocClassName,DocClassDesc, ROW_NUMBER() OVER(order by ID) as row from Sys_DocClass ) a where row between 20 and 30

转载于:https://www.cnblogs.com/lfzwenzhu/archive/2009/03/17/1414142.html