Table 136. Quantile Function
Field | Description |
|---|---|
Description | Computes the quantile scores for the values in a column. A quantile is a generic interval of user-defined width. |
Syntax: | Quantile(quantile_constant, sort_expression_list) |
quantile_constant | A positive integer constant used to define the number of quantile partitions to be used. |
sort_expression_list | List of expressions (with optional sort direction specifications) separated by commas. That is, it specifies the column references used to sort the values. The default sort direction is ascending (ASC). |
Quantile Value Range | 0 through (Q-1) where Q is the number of quantile partitions specified by the quantile constant. |