Difference between revisions of "Percentile"
(jrfconvert import) |
|||
| Line 1: | Line 1: | ||
| − | [[Category: | + | [[Category:Functions_Used_in_where_Expressions]] |
| | ||
Revision as of 05:21, 28 March 2011
percentile
Calculate the 100-quantiles.
Syntax
percentile(dcsColumn, pct)
Arguments
dcsColumn: is a numeric dcs column (column whose data type is Number)
pct: an integer number. (0 < pct < 100)
Example
percentile(C1, 25) where C2 == 1;
Availability
Version 5.2
