title: SQL: Select only one row of table with same value
body: <p>Im a bit new to sql and for my project I need to do some Database sorting and filtering:</p>
  
  <p>Let's assume my database looks like this:</p>
  
  <pre><code>==========================================
  |  id       |       email        | name
  ==========================================
  |   1       |  123@test.com      | John
  |   2       |  234@test.com      | Peter
  |   3       |  234@test.com      | Steward
  |   4       |  123@test.com      | Ethan
  |   5       |  542@test.com      | Bob
  |   6       |  123@test.com      | Patrick
  ==========================================
  </code></pre>
  
  <p>What should I do to only have the last column with the same email te be returned:</p>
  
  <pre><code>==========================================
  |  id       |       email        | name
  ==========================================
  |   3       |  234@test.com      | Steward
  |   5       |  542@test.com      | Bob
  |   6       |  123@test.com      | Patrick
  ==========================================
  </code></pre>
  
  <p>Thanks in advance!</p>