declare @pageIndex int
declare @pageSize int
set @pageIndex=1
set @pageSize=15
select FMASTERID from T_BD_MATERIAL order by FMASTERID OFFSET ((@pageIndex-1)*@pageSize) ROW FETCH NEXT @pageSize rows only
@pageIndex 第几页
@pageSize 每页显示多少行
declare @pageIndex int
declare @pageSize int
set @pageIndex=1
set @pageSize=15
select FMASTERID from T_BD_MATERIAL order by FMASTERID OFFSET ((@pageIndex-1)*@pageSize) ROW FETCH NEXT @pageSize rows only
@pageIndex 第几页
@pageSize 每页显示多少行