title: SELECT DISTINCT TOP 5 in SQL Server
body: <p>I can't get this sql query right...</p>
  
  <p>I want the top 5 latest comments from <code>tblComment</code>. The problem is that I get more then one comment with the same <code>ProductID</code>. I don't want that.</p>
  
  <pre><code>SELECT DISTINCT TOP 5
     tblProduct.ProductID, 
     tblProduct.ProductName, 
     tblComment.DateAdded
  FROM   
      tblComment 
  INNER JOIN 
      tblProduct ON tblProduct.ProductID = tblComment.ProductID
  ORDER BY 
      tblComment.DateAdded DESC
  </code></pre>
  
  <p>What am I doing wrong?</p>