Select Where Count() of multiple columns is greater than one
<p>Say I have data like this:</p>

<pre><code>ClaimID ClaimLine    Date
   1        1     22/06/2016
   1        1     01/01/2016
   2        1     08/06/2016
   2        2     31/01/2015
   3        1     23/03/2013
</code></pre>

<p>How would I select the duplicate ClaimIDs and ClaimLine with the lowest date?</p>

<p>So the return value would be</p>

<pre><code>1,1,01/01/2016
</code></pre>