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