Click or drag to resize

WindowFunctionsLag Method (Object, Object, Object)

Creates a LAG(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
Copy
public static FunctionMappingExpression Lag(
	Object scalar_expression,
	Object offset,
	Object defaultValue
)

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