PERCENTILE_CONT
PERCENTILE_CONT is an inverse distribution function that assumes a continuous distribution model. It takes a percentile value and a sort specification, and returns an interpolated value that would fall into that percentile value with respect to the sort specification.
Syntax
PERCENTILE_CONT (expression) WITHIN GROUP (ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] ) OVER (PARTITION BY expression [, ...] )
Remarks
• NULLs are ignored in the calculation.
• PARTITION BY is required if an OVER clause is used.
• Without an OVER clause, PERCENTILE_CONT is a simple aggregate function.