- Data Engineering Integration 10.2.1
- All Products
StartDate Ascending. Arranges the data chronologically by ascending start date.
CustomerCode. Groups the rows according to customer code so that calculations are based on individual customers.
Not specified. Window functions access rows based on the offset argument and ignore the frame specification.
LEAD ( StartDate, 1, '01-Jan-2100' )
ADD_TO_DATE ( LEAD ( StartDate, 1, '01-Jan-2100' ), 'DD', -1, )
Updated October 23, 2019