0 - 1 of 1 tags for first_value

ORACLE's FIRST_VALUE() and LAST_VALUE analytic function is pretty handy. In TD 13 and 14, how can we achieve the same result with limited effort?

The old-fashioned way is to achieve FIRST_VALUE(PROMOTION_ID), LAST_VALUE(SHIP_TO_ADDR_ID):