<div>
I'm not sure, but will this do what you described?<br />
<br />
Latest Date for each group:<br />
<br />
Select Group, Max(Date)<br />
From Table<br />
Group By Group<br />
<br />
<br />
Earliest Date for each group:<br />
<br />
Select Group, Min(Date)<br />
From Table<br />
Group By Group<br />

</div>


I'm not sure, but will this do what you described?

Latest Date for each group:

Select Group, Max(Date)
From Table
Group By Group


Earliest Date for each group:

Select Group, Min(Date)
From Table
Group By Group


<div>
you can also combine the two above...<br />
<br />
select Group, max(date), min(date)<br />
from Table<br />
group by group
</div>


you can also combine the two above...

select Group, max(date), min(date)
from Table
group by group

<div>
Thanks: &nbsp;I got distracted from this project for quite a while.
</div>


Thanks:  I got distracted from this project for quite a while.

<div>
<div class="content wysiwyg-content">
I have a table that contains a DateTime column, and another column that I want to use as the group indicator. &nbsp;I haven't found a function that will select the latest or earliest of the DateTime values for each group. &nbsp;Does one exist?<br />
<br />
Thanks
</div>
</div>


I have a table that contains a DateTime column, and another column that I want to use as the group indicator.  I haven't found a function that will select the latest or earliest of the DateTime values for each group.  Does one exist?

Thanks

Aggregate function for DateTime variables??

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.