Click or drag to resize

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.6.0.0 (5.6.19.0117)
Syntax
Copy
public static FunctionMappingExpression NthValue(
	Object scalar_expression,
	long offset
)

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: FunctionMappingExpression
Function mapping expression representing the function call
Remarks
Be sure to append an Over() clause to this function call.
See Also