Netezza Performance Server

 View Only
  • 1.  Translating Oracle KEEP DENSE RANK Function to Netezza.

    Posted 17 days ago
    Edited by David Briars 2 days ago
    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
    ------------------------------


  • 2.  RE: Translating Oracle KEEP DENSE RANK Function to Netezza.

    Posted 2 days ago
    Looks like the Netezza analytical function LAST_VALUE is what I needed to use...

    LAST_VALUE(fa.action)
    OVER (PARTITION BY ff.id
    ORDER BY fm.open_date
    ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
    as max_action

    ------------------------------
    David Briars
    ------------------------------