hard20 pts · first answer countswindow-functionssql

Median per department in PostgreSQL

An analyst writes PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary) OVER (PARTITION BY dept) in PostgreSQL and gets an error. Why?

A.In PostgreSQL it is an ordered-set aggregate, not a window functionB.PERCENTILE_CONT only accepts 0.25 and 0.75C.It needs ROWS BETWEEN UNBOUNDED PRECEDING in the OVERD.Median cannot be computed on salary data types

Discussion 0

Join free to post in the discussion.

Median per department in PostgreSQL

Discussion 0

Related questions