Skip to content
RED SAGSkills
hard20 pts · first answer countssqlstatistics

PERCENTILE_CONT vs PERCENTILE_DISC

The values are 1, 2, 3 and 4. What do these two expressions return?

SELECT
  PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY x),
  PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY x)
FROM v;
Choose one answer