SQL Select Distinct column and latest date
<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>