title: SQL get products of each category with OFFSET / FETCH
body: <p>I have this query to print 10 product with each category</p>
  
  <pre><code>WITH MyRowSet AS (SELECT *, 
          ROW_NUMBER() OVER (PARTITION BY p.cateID ORDER BY p.cateID DESC) 
          AS RowNum 
          FROM Product p )  
  SELECT TOP 100 * FROM MyRowSet WHERE RowNum &lt;= 10
  </code></pre>
  
  <p>Then I want to get the next 100 products with OFFSET / FETCH. How I can do this?</p>