sql分页查询

declare @pageSize int, @pageIndex int
set @pageIndex=0
set @pageSize=10
print @pageSize
select B.* from
(
select ROW_NUMBER() over(order by id) as RowNo,* from TestTable
)
as A
inner join TestTable as B on A.ID=B.ID
where RowNo > @pageSize * @pageIndex
and RowNo <= @pageSize * @pageIndex + @pageSize