how to calculate median on azure databricks delta table using sql

[PadamTripathi]

how to calculate median on delta tables in azure databricks using sql ?

select col1, col2, col3, median(col5) from delta table group by col1, col2, col3

[-werners-]

try with the percentile function, as median = percentile 50:

https://spark.apache.org/docs/latest/api/sql/#percentile

[StevenTillson02]

Thank you for youur comment. It worked.