WindowFunctions Methods |
The WindowFunctions type exposes the following members.
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.) |