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 
posted @ 2006-09-26 23:42  greystar  阅读(99)  评论(0)    收藏  举报