PERCENTILE_CONT/PERCENTILE_DISC Function Example | Teradata Vantage - Example - Analytics Database - Teradata Vantage

Using this table:

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

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;