select top(@pageSize) * from TableName
where Id>
(select isnull(max (Id),1) from
(select top((@pageNumber-1)*@pageSize) Id from TableName order by Id) as T
)
order by Id
select top(@pageSize) * from TableName
where Id>
(select isnull(max (Id),1) from
(select top((@pageNumber-1)*@pageSize) Id from TableName order by Id) as T
)
order by Id