PERCENTILE_DISC()

Overview

A description for this Function has not yet been added to this Documentation.

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

CREATE TABLE t1 (a INT, b INT);
INSERT INTO t1 VALUES
  (1,3), (1,5), (8,2), (5,7), (5,6),
  (10,1), (6,4), (3,9), (3,9), (7,2),
  (7,5), (2,6), (9,10), (9,5), (4,8);
SELECT a,
  PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY b)
    OVER (PARTITION BY a) AS pc
FROM t1;
+------+------+
| a    | pc   |
+------+------+
|    1 |    3 |
|    1 |    3 |
|    2 |    6 |
|    3 |    9 |
|    3 |    9 |
|    4 |    8 |
|    5 |    6 |
|    5 |    6 |
|    6 |    4 |
|    7 |    2 |
|    7 |    2 |
|    8 |    2 |
|    9 |    5 |
|    9 |    5 |
|   10 |    1 |
+------+------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES