SQL分页语句

1、可行的sql语句：select   top   每页多少*第几页   *   from   A
where   A.主键   not   in   (select   top   每页多少*(第几页-1)   A.主键   from   A     )
2、with temp as ( select row_number() over(order by nUserId) as rownum,cUserName from TUser )

select * from temp where rownum between 10 and 20

go

3、select * from (select Row_Number() over(order by nUserId) as rowId,* from TUser) u where u.rowId between 10 and 20