load serial, Max(log_date), logged_value

[#1]

Hi All,

I need some help here.  I have 3 fields: AC_SERIAL, LOG_DATE and LOG_VALUE.

I want to load in the max(log_date) for each aircraft and return the single log_value for that date.  I need help.  Thanks.

[swuehl]

Try

Load    

AC_SERIAL ,

max(LOG_DATE),

FirstSortedValue(LOG_VALUE, -LOG_DATE )

FROM ... GROUP BY AC_SERIAL;