title: DISTINCT for only one column
body: <p>Let's say I have the following query.</p>
  
  <pre><code>SELECT ID, Email, ProductName, ProductModel FROM Products
  </code></pre>
  
  <p>How can I modify it so that it returns no duplicate Emails?</p>
  
  <p>In other words, when several rows contain the same email, I want the results to include only one of those rows (preferably the last one). Duplicates in other columns should be allowed.</p>
  
  <p>Clauses like <code>DISTINCT</code> and <code>GROUP BY</code> appear to work on entire rows. So I'm not sure how to approach this.</p>