选择Sql2005分页的方法
select OID ,Pos from(
select OID, ROW_NUMBER() OVER (order by OID) as Pos from directoryRights
) as T
where T.Pos > 1 and T.Pos < 10
本文地址：http://www.45fan.com/a/question/70118.html
45fan.com - 路饭网
选择Sql2005分页的方法
(
select OID, ROW_NUMBER() OVER (order by OID) as Pos from directoryRights
) as T
where T.Pos > 1 and T.Pos < 10
本文地址：http://www.45fan.com/a/question/70118.html
相关文章列表