I am having the hardest time converting the following Oracle code to Netezza:
-- most recent action
MAX(fa.action)
KEEP ( DENSE_RANK LAST ORDER BY fm.open_date )
OVER ( PARTITION BY ff.id )
as max_action,
Any assistance appreciated.
'open_date' can contain nulls.
------------------------------
David Briars
------------------------------
#NetezzaPerformanceServer