Hi
i have the following query, which i thought would give me the maximum date for each record_id however, it does not.
Any assistance would be greatly appreciated:
select fk_fha_number,max(date_final_settlement) max_settlement_date
from mf_fha_claim
where date_final_settlement is not null
and fk_fha_number in ( 06435113,
07135575,
09235585,
09235599,
06235384,
10135218,
09235399,
08544032,
08435265,
08535312)
group by fk_fha_number,date_final_settlement
order by fk_fha_number
Results
fk_fha_number Max_date_settlement
06235384 1999-09-08 00:00:00.000
06235384 2004-01-30 00:00:00.000
06435113 1995-09-27 00:00:00.000
07135575 1997-05-27 00:00:00.000
07135575 2007-11-15 00:00:00.000
08435265 1999-08-03 00:00:00.000
08435265 2005-03-17 00:00:00.000
08535312 1990-06-08 00:00:00.000
08535312 2004-09-24 00:00:00.000
08544032 1999-06-24 00:00:00.000
08544032 2005-03-23 00:00:00.000
09235399 2012-02-01 00:00:00.000
09235585 2009-06-17 00:00:00.000
09235585 2009-09-22 00:00:00.000
09235599 2009-06-09 00:00:00.000
09235599 2009-09-22 00:00:00.000
10135218 2002-01-28 00:00:00.000
10135218 2005-09-30 00:00:00.000
{Resolved}Need help getting max date
Posted - 03/28/2012 : 16:34:39
