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...

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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！