PERCENTILE_CONT/PERCENTILE_DISC Function Example | Teradata Vantage - Example - Advanced SQL Engine - Teradata Database

Using this table:

the following SQL statement returns a computed result after doing linear interpolation, as shown in the table immediately below.

SELECT area,
       AVG(price),
       PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY price),
       PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price)
FROM market
GROUP BY area;