Posted on 2001-07-18
Have a View with fields:
Date_Month (Extracts the month from above date)
Date_Yr (Extracts the year from above date)
The data is collected on a monthly basis, also the data might miss for some months.
I want to write a sql that for a given year gives me the latest data for that year.
ie, lets say data was collected for Jan, Feb, May for 2001
If the sql was ran today the output would be May's value (ie. the data was recorded in May for yr-2001)