WindowFunctionsLead Method (Object, Object, Object) |
Creates a LEAD(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
Namespace:
SD.LLBLGen.Pro.QuerySpec
Assembly:
SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.11.0.0 (5.11.23.1114)
Syntax public static FunctionMappingExpression Lead(
Object scalar_expression,
Object offset,
Object defaultValue
)
Public Shared Function Lead (
scalar_expression As Object,
offset As Object,
defaultValue As Object
) As FunctionMappingExpression
Parameters
- scalar_expression
- Type: SystemObject
the value to return - offset
- Type: SystemObject
The number of rows back from the current row from which to obtain a value. offset can be a column, subquery,
or other expression that evaluates to a positive integer or can be implicitly converted to bigint. offset cannot be a negative value - defaultValue
- Type: SystemObject
the default value to return if the row at offset is NULL
Return Value
Type:
FunctionMappingExpressionFunction mapping expression representing the function call
Remarks Be sure to append an Over() clause to this function call.
See Also