title: Eliminating duplicate values based on only one column of the table
body: <p>My query:</p>
  
  <pre><code>SELECT sites.siteName, sites.siteIP, history.date
  FROM sites INNER JOIN
       history ON sites.siteName = history.siteName
  ORDER BY siteName,date
  </code></pre>
  
  <p>First part of the output:</p>
  
  <p><img src="https://i.stack.imgur.com/D0Lpg.png" alt="enter image description here"></p>
  
  <p>How can I remove the duplicates in <code>siteName</code> column? I want to leave only the updated one based on <code>date</code> column.</p>
  
  <p>In the example output above, I need the rows 1, 3, 6, 10</p>