Min_Date with Condition [英] Min_Date with Condition

问题描述

ID    Date
1     23/02/2011
1     23/02/2012
1     23/02/2013
1     23/03/2013
2     23/02/2011
2     23/02/2012
2     23/02/2013
2     23/03/2013

这是我的结果集，基于我想要获取min_date的id。



如何要做到这一点...



关于此的任何帮助...

This is my result set , in that based on id i want to fetch min_date.

How to do that...

Any help regarding this...

推荐答案

以下查询将返回每个ID的最小日期。

The following query will return Min date for each ID.

SELECT ID, Min(Date) As SmallDate FROM [Your Table]
Group BY ID;

如果你想过滤你可以使用

If you want to filter that you can use

SELECT ID, Min(Date) As SmallDate FROM [Your Table]
Group BY ID HAVING Id = @Id;--Your parameter id

另一个

Another

SELECT ID, Min(Date) As SmallDate FROM [Your Table]
Group BY ID HAVING Id = (SELECT MIN(Id) FROM [Your Table]);--Minimum Id

这篇关于Min_Date with Condition的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！