WindowFunctionsPercentileCont Method |
Creates a PERCENTILE_CONT(numeric_literal) WITHIN GROUP (ORDER BY orderbyClause) function call returning value of type System.Double.
Namespace:
SD.LLBLGen.Pro.QuerySpec
Assembly:
SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.6.0.0 (5.6.19.0117)
Syntax public static FunctionMappingExpression PercentileCont(
double numeric_literal,
ISortClause orderbyClause
)
Public Shared Function PercentileCont (
numeric_literal As Double,
orderbyClause As ISortClause
) As FunctionMappingExpression
Parameters
- numeric_literal
- Type: SystemDouble
the percentile to compute - orderbyClause
- Type: SD.LLBLGen.Pro.ORMSupportClassesISortClause
Specifies the ordering of the list of numeric values to compute the percentile over.
Return Value
Type:
FunctionMappingExpressionFunction mapping expression representing the function call
Remarks Be sure to append an Over() clause to this function call. Orderby and window bounds aren't allowed in the Over clause for this function
See Also