WindowFunctionsNthValue Method |
Creates a NTH_VALUE(scalar_expression, offset) 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.5.0.0 (5.5.18.1019)
Syntax public static FunctionMappingExpression NthValue(
Object scalar_expression,
long offset
)
Public Shared Function NthValue (
scalar_expression As Object,
offset As Long
) As FunctionMappingExpression
Parameters
- scalar_expression
- Type: SystemObject
the value to return - offset
- Type: SystemInt64
The offset of the nth row of the window frame (counting from 1)
Return Value
Type:
FunctionMappingExpressionFunction mapping expression representing the function call
Remarks Be sure to append an Over() clause to this function call.
See Also