简单分页SQL

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