PERCENTILE_CONT « Analytical Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Analytical Functions
  3. PERCENTILE_CONT
16.21.PERCENTILE_CONT
16.21.1.Take a probability value (between 0 and 1) and returns a percentile value (for a continuous distribution)
16.21.2.PERCENTILE_CONT(x) examines the percent rank values in each group until it finds one that is greater than or equal to x
16.21.3.select percentile_cont(0.5) within group (order by salary desc )