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