sql server常用的分页

select top  pagesize *  from dbo.table where Id not in (select top ((pageindex-1)*pagesize) Id from dbo.table )