--说明:供自己参考
--sqlserver 2005以上版本
select * from(
select h.id,h.objname, ROW_NUMBER() OVER(order by h.id) as pon from humres h
)as t where t.pon between 1 and 20
--说明:供自己参考
--sqlserver 2005以上版本
select * from(
select h.id,h.objname, ROW_NUMBER() OVER(order by h.id) as pon from humres h
)as t where t.pon between 1 and 20