Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try
Load
AC_SERIAL ,
max(LOG_DATE),
FirstSortedValue(LOG_VALUE, -LOG_DATE )
FROM ... GROUP BY AC_SERIAL;