PowerCenter
- PowerCenter 10.5.6
- All Products
LEAD (column_name,offset,default)
Argument
| Required/
Optional
| Description
|
---|---|---|
column_name
| Required
| The target column or expression that the function operates on.
|
offset
| Required
| Integer data type. The number of rows after the current row to obtain a value from.
|
default
| Optional
| The default value to be returned in case the offset is outside the bounds of the partition or table. Default is NULL.
|
LEAD ( HIRE_DATE, 1, NULL )
|
|
|
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LEAD ( Sales_Quota, 2, 0 ) - Sales_Quota
|
|
|
|
---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|