本文介绍了如何从卡号区别选择日期值的最大值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

ProcessDate ProcessTime CardNo  EffectiveDate   EffectiveTime   ExpireDate  ExpireTime
12/21/2011  10:04:14    0749    12/21/2011       00:00
12/21/2011  10:06:04    0749    12/21/2011       00:00
12/21/2011  23:17:37    0095    12/21/2011       00:00
12/29/2011  16:26:57    0095    12/29/2011       00:00
07/09/2013  13:00:14    0749    07/09/2013       00:00
07/09/2013  14:33:24    0749    07/09/2013       00:00
07/10/2013  12:42:58    0749    07/10/2013       12:30
08/01/2013  11:39:59    0019    01/08/2013       11:30
12/21/2011  10:30:20    0749                                       12/21/2011  10:30
01/31/2012  00:00:38    0095                                       01/31/2012  00:00
07/09/2013  14:33:26    0749                                       07/09/2013  14:30
07/10/2013  12:30:03    0749                                       07/10/2013  12:30
07/10/2013  13:23:15    0749                                       07/10/2013  13:00
07/10/2013  14:28:59    0749                                       07/10/2013  14:00
08/11/2013  14:59:23    0749                                       07/10/2013  14:30

I need to select the maximum value of EffectiveDate (MM/dd/yyyy).but that EffectiveDate  is taken in string value and also search by CardNo also. that code also write in below is there.

 i Want Result would be:

ProcessDate ProcessTime CardNo  EffectiveDate   EffectiveTime   ExpireDate ExpireTime

07/10/2013  12:42:58    0749    07/10/2013  12:30

12/29/2011  16:26:57    0095    12/29/2011       00:00

08/01/2013  11:39:59    0019    01/08/2013       11:30


but i tried one code.

var AutoEffectExpireData = " SELECT * FROM (SELECT AutoEffectExpireData.CardNo,Max(AutoEffectExpireData.EffectiveDate) AS EffectiveDate FROM AutoEffectExpireData GROUP BY AutoEffectExpireData.CardNo ) AS CardNo INNER JOIN AutoEffectExpireData t1 ON CardNo.CardNo = t1.CardNo and CardNo.EffectiveDate = t1.EffectiveDate ";


but output is came like this.

ProcessDate ProcessTime CardNo  EffectiveDate   EffectiveTime   ExpireDate  ExpireTime

12/21/2011  10:04:14    0749    12/21/2011       00:00

12/29/2011  16:26:57    0095    12/29/2011       00:00

08/01/2013  11:39:59    0019    01/08/2013       11:30

推荐答案


这篇关于如何从卡号区别选择日期值的最大值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-20 17:48