title: How do I remove duplicates in paging
body: <p>table1 &amp; table2:</p>
  
  <p><a href="http://aftabfarda.parsfile.com/1.png" rel="nofollow noreferrer">table1 &amp; table2 http://aftabfarda.parsfile.com/1.png</a></p>
  
  <pre><code>SELECT     *
  FROM         (SELECT DISTINCT dbo.tb1.ID, dbo.tb1.name, ROW_NUMBER() OVER (ORDER BY tb1.id DESC) AS row
  FROM         dbo.tb1 INNER JOIN
                        dbo.tb2 ON dbo.tb1.ID = dbo.tb2.id_tb1) AS a
  WHERE     row BETWEEN 1 AND 7
  ORDER BY id DESC
  </code></pre>
  
  <p>Result:</p>
  
  <p><a href="http://aftabfarda.parsfile.com/3.png" rel="nofollow noreferrer">Result... http://aftabfarda.parsfile.com/3.png</a></p>
  
  <p>(id 11 Repeated 3 times)</p>
  
  <p>How can I have this output:</p>
  
  <pre><code>ID  name    row
  --  ------  ---
  11  user11  1
  10  user10  2
  9   user9   3
  8   user8   4
  7   user7   5
  6   user6   6
  5   user5   7
  </code></pre>