SELECT TOP 每页记录数*页码 FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNumber,* FROM TABLE ) as A WHERE RowNumber > 每页记录数*(页码-1)