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.8.0.0 (5.8.21.0111)

Syntax

Copy

public static FunctionMappingExpression Lag(
	Object scalar_expression,
	Object offset,
	Object defaultValue
)

Public Shared Function Lag ( 
	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: FunctionMappingExpression
Function mapping expression representing the function call

Remarks

Be sure to append an Over() clause to this function call.

Reference

WindowFunctions Class

Lag Overload

SD.LLBLGen.Pro.QuerySpec Namespace

WindowFunctionsAddLanguageSpecificTextSet("LSTDBBF8896_0?cpp=::|nu=.");Lag Method (Object, Object, Object)

Parameters

Return Value

Reference

WindowFunctionsLag Method (Object, Object, Object)