Data Engineering Integration
- Data Engineering Integration 10.2.2 Service Pack 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 January 20, 2020