title: SQL Select Distinct column and latest date
body: <p>I'm looking to select just the latest records of a table based on date, but only one one Distinct listing of each of the urls.  The table structure is like this;</p>
  
  <pre><code>ID        URL          DateVisited
  1         google.com   01-01-2016
  2         yahoo.com    01-02-2016
  3         google.com   12-30-2015
  4         google.com   02-01-2016
  </code></pre>
  
  <p>So for my result set I would want</p>
  
  <pre><code>google.com     02-01-2016
  yahoo.com      01-02-2016
  </code></pre>
  
  <p>I will have a couple more conditionals in my actual query, but just want to get the single latest records in a hit log, rather than  list of distinct urls and dates, just distinct url's and the latest date.</p>