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;