Extracting the latest date from a query

hello expert,

I am attempting to extract info for the latest date that a memo was applied to accounts in a database


An account is consider dormant if there is no withdawal done in the past 6 months if a withdrawal in

done on dormant account the memo code 'REAC' is applied to the said account to notify all that the

once dormant account had a withdrawal done.

I have design a query to capture all ACCOUNTS with the memo 'REAC' applied .

But an account may have had REAC applied serval times during the period i am searching

01-jan-01 to 09-mar-07

How can modify may query to report the date of the latest REAC memo.



>> spool react.txt
set linesize 132
set pagesize 62
break on report skip 2
set head off
select  'DAILY REACT REPORT
                                         Date : '|| to_char(sysdate,'dd/mm/yyyy'
)
from v$parameter
where name = 'db_name'
;
set head on
break on till_no skip 1
select
substr(alt_acc_no,1,7) " NBS ",
substr(a.acc_name,1,52) Name,
to_char(decode(b.dr_cr,'C',0,tran_amt),'$99,999,999.99') "      Debit",
substr(user_name,1,9) "  USER NAME  ",
to_char(f.curbal,'$9,999,999,999.99') "  BALANCE  "
,substr(DESCRIPT,1,10) "  TYPE  "
from save_tran t, save_acc a,users u,save_finl f,memo_appl m
,base_type b,altern_acc n
where t.acc_no = a.acc_no
and t.base_code = b.base_code
and a.acc_no = f.acc_no
and t.user_id = u.user_id
and appl_id_a = f.acc_no
and n.acc_no(+) = t.acc_no
and  m.memo_code ='REAC'
and tran_code not in ('5','4','24','905','704','924','8','146')
and user_type = 'A'
and deleted is null
and branch not in '06'
and t.user_id not like '%FOREDBA%'
and proc_date between '&proc_date' and '&proc_date')
and date_appl between '&date_appl' and '&date_appl')
order by acc_name
/

thanks