title: Paging by groups of records instead of rows
body: <p>I have a query that returns the following:</p>
  
  <pre><code>ID   Rank
  1     1
  2     1
  3     2
  4     3
  5     4
  6     4
  </code></pre>
  
  <p>I am trying to use the OFFSET / FETCH NEXT at the end to return the records paged </p>
  
  <p>I.E. if I only want 3 rows per page and I want page 1, I would pass a 1 to @Page, and 3 to @PageRecordCount below, and for page 2, a @Page = 2 to get page 2 and so on...</p>
  
  <pre><code>OFFSET (@Page - 1) * @PageRecordCount  ROWS
  FETCH NEXT @PageRecordCount ROWS ONLY;
  </code></pre>
  
  <p>If I need the full grouping of records for each page, how can I accomplish this? </p>
  
  <p>What I am expecting is as follows:
  @Page = 1
  @PageRecordCount = 3</p>
  
  <p>Return:</p>
  
  <pre><code>ID
  1
  2
  3
  4
  </code></pre>
  
  <p>I want to return the number of groupings, rather than the number of rows. Is this possible?</p>