Hi,
 
I'm trying to write an SQL statement based on this example data (just the first 3 columns)
 
OUTLET_ID DATE_ID      QUALITY_FLAG Count
799              01.06.2014   1            
799              02.06.2014   1

Hi All,
 
I have the below requirement.
 
Incoming data

ID  Status         Start Date

1   Active              7-Aug 

1   Suspended     8-Aug 

1   Active              9-Aug 

1   Active             10-Aug 

1   Suspended     11-Aug 
 
I should get the below output.

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):