Select only the most recent line of a table based on a field : <p>Given the following table:</p>

<pre><code>Column1   Column2        Column3
Name1     "2016-05-11"   Value1
Name2     "2016-05-11"   Value2
Name2     "2015-05-17"   Value3
Name3     "2014-07-31"   Value4
Name4     "2011-07-31"   Value5
Name4     "2013-07-31"   Value6
Name4     "2016-09-31"   Value7
</code></pre>

<p>How do I select only the most recent value from Column2 for each Column1 value.
So the query result would be this:</p>

<pre><code>Column1   Column2        Column3
Name1     "2016-05-11"   Value1
Name2     "2016-05-11"   Value2
Name3     "2014-07-31"   Value4
Name4     "2016-09-31"   Value7
</code></pre>
