<div>
Hi jfmckenzie,<br />
<br />
SELECT ID, MAX(LastContactDate)LastCo<wbr />ntactDate<br />
FRoM urTable<br />
GROUP BY ID<br />
<br />
<br />
Aneesh R!
</div>


Hi jfmckenzie,

SELECT ID, MAX(LastContactDate)LastContactDate
FRoM urTable
GROUP BY ID


Aneesh R!

<div>
Thanks guys. Both comments correct, not sure how to allocate points so just accepted first answer.
</div>


Thanks guys. Both comments correct, not sure how to allocate points so just accepted first answer.

<div>
&gt;&gt;not sure how to allocate points &lt;&lt;<br />
See here from the EE Help:<br />
<br />
More than one Expert helped solve my problem. What do I do?<br />
<a href="https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi69" rel="ugc nofollow">https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi69</a>
</div>


>>not sure how to allocate points <<
See here from the EE Help:

More than one Expert helped solve my problem. What do I do?
https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi69 [https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi69]

<div>
<div class="content wysiwyg-content">
My current query retrieves the following data<br />
<br />
&lt;Current Resultset&gt;<br />
<br />
id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LastContactDate<br />
<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10-jan-06<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11-jan-06<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12-jan-06<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10-feb-06<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11-feb-06<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12-feb-06<br />
<br />
I need to be able to select only the latest date for each record id.<br />
<br />
&lt;Required Resultset&gt;<br />
<br />
id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LastDateContact<br />
<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12-jan-06<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12-feb-06<br />
<br />
<br />
Thanks in advance
</div>
</div>


My current query retrieves the following data

<Current Resultset>

id             LastContactDate

1              10-jan-06
1              11-jan-06
1              12-jan-06
2              10-feb-06
2              11-feb-06
2              12-feb-06

I need to be able to select only the latest date for each record id.

<Required Resultset>

id             LastDateContact

1              12-jan-06
2              12-feb-06


Thanks in advance

How to: Select Last Record for Each Record ID

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.