https://community.databricks.com/t5/data-engineering/how-to-calculate-median-on-azure-databricks-delta-table-using/m-p/16137#M10349 <P></P> <P>how to calculate median on delta tables in azure databricks using sql ?</P> <P>select col1, col2, col3, median(col5) from delta table group by col1, col2, col3 </P> <P></P> Fri, 20 Aug 2021 19:04:18 GMT PadamTripathi 2021-08-20T19:04:18Z https://community.databricks.com/t5/data-engineering/how-to-calculate-median-on-azure-databricks-delta-table-using/m-p/16137#M10349 <P></P> <P>how to calculate median on delta tables in azure databricks using sql ?</P> <P>select col1, col2, col3, median(col5) from delta table group by col1, col2, col3 </P> <P></P> Fri, 20 Aug 2021 19:04:18 GMT https://community.databricks.com/t5/data-engineering/how-to-calculate-median-on-azure-databricks-delta-table-using/m-p/16137#M10349 PadamTripathi 2021-08-20T19:04:18Z https://community.databricks.com/t5/data-engineering/how-to-calculate-median-on-azure-databricks-delta-table-using/m-p/16138#M10350 <P></P> <P>try with the percentile function, as median = percentile 50:</P> <P><A href="https://spark.apache.org/docs/latest/api/sql/#percentile" target="test_blank">https://spark.apache.org/docs/latest/api/sql/#percentile</A></P> <P></P> Mon, 23 Aug 2021 09:14:41 GMT https://community.databricks.com/t5/data-engineering/how-to-calculate-median-on-azure-databricks-delta-table-using/m-p/16138#M10350 -werners- 2021-08-23T09:14:41Z https://community.databricks.com/t5/data-engineering/how-to-calculate-median-on-azure-databricks-delta-table-using/m-p/16139#M10351 <P></P> <P>Thank you for youur comment. It worked.</P> <P></P> Mon, 23 Aug 2021 12:46:41 GMT https://community.databricks.com/t5/data-engineering/how-to-calculate-median-on-azure-databricks-delta-table-using/m-p/16139#M10351 StevenTillson02 2021-08-23T12:46:41Z