I have this SQL where i search all data entered since 01/01/2009.
But i want to extract all last "ff.access_id," added in the database based on "ff.effective_dt," since 01/01/2009
Last records of certain "ff.access_id," may be from last year. But this is what i'm trying to do.
and ff.effective_dt >= to_date('01/01/2009','mm/dd/rrrr')
I just want to extract all ff.region_id but only the last effective date per ff.region_id.
How can i do this please?
Thanks for your help