title: Implement paging (skip / take) functionality with this query
body: <p>I have been trying to understand a little bit about how to implement custom paging in SQL, for instance reading <a href="https://stackoverflow.com/questions/548475/efficient-way-to-implement-paging">articles like this one</a>.</p>
  
  <p>I have the following query, which works perfectly. But I would like to implement paging with this one.</p>
  
  <pre><code>SELECT TOP x PostId FROM ( SELECT PostId, MAX (Datemade) as LastDate
   from dbForumEntry 
   group by PostId ) SubQueryAlias
   order by LastDate desc
  </code></pre>
  
  <p><strong>What is it I want</strong></p>
  
  <p>I have forum posts, with related entries. I want to get the posts with the latest added entries, so I can select the recently debated posts.</p>
  
  <p>Now, I want to be able to get the "top 10 to 20 recently active posts", instead of "top 10".</p>
  
  <p><strong>What have I tried</strong></p>
  
  <p>I have tried to implement the ROW functions as the one in the article, but really with no luck. </p>
  
  <p>Any ideas how to implement it?</p>