WindowFunctions Class

Class which defines window (analytical) functions so they can be used within a queryspec query combined with a windowspecification, defined by appending an Over() method call.

Inheritance Hierarchy

SystemObject
SD.LLBLGen.Pro.QuerySpecWindowFunctions

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 class WindowFunctions

Public Class WindowFunctions

The WindowFunctions type exposes the following members.

Constructors

	Name	Description
	WindowFunctions	Initializes a new instance of the WindowFunctions class

Top

Methods

	Name	Description
	CumeDist	Creates a CUME_DIST() function call returning a value of type System.Double.
	DenseRank	Creates a DENSE_RANK() function call returning value of type System.Int64.
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	FirstValue	Creates a FIRST_VALUE(scalar_expression) function call returning a value of the type the scalar_expression resolves to.
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	Lag(Object)	Creates a LAG(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
	Lag(Object, Object)	Creates a LAG(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
	Lag(Object, Object, Object)	Creates a LAG(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
	LastValue	Creates a LASTVALUE(scalar_expression) function call returning a value of the type the scalar_expression resolves to.
	Lead(Object)	Creates a LEAD(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
	Lead(Object, Object)	Creates a LEAD(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
	Lead(Object, Object, Object)	Creates a LEAD(scalar_expression, offset, defaultValue) function call returning a value of the type the scalar expression resolves to
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	NthValue	Creates a NTH_VALUE(scalar_expression, offset) function call returning a value of the type the scalar_expression resolves to.
	Ntile	Creates a NTILE(integer_expression) function call returning a value of the type System.Int64.
	PercentileCont	Creates a PERCENTILE_CONT(numeric_literal) WITHIN GROUP (ORDER BY orderbyClause) function call returning value of type System.Double.
	PercentileDisc	Creates a PERCENTILE_DISC(numeric_literal) WITHIN GROUP (ORDER BY orderbyClause) function call returning value of type System.Double.
	PercentRank	Creates a PERCENT_RANK() function call returning value of type System.Double.
	Rank	Creates a RANK() function call returning value of type System.Int64.
	RowNumber	Creates a ROW_NUMBER() function call returning value of type System.Int64.
	ToString	Returns a string that represents the current object. (Inherited from Object.)

Top

Reference

SD.LLBLGen.Pro.QuerySpec Namespace