How to Calculate or Find median in SQL Server

Description:

In this example we explain that how to calculate median in SQL Server. Or function to find median in SQL Server. Before we calculate/find median in sql server first we understand the what is the median and formula to calculate the median in sql server.

What is Median?

Median means denoting or relating to a value or quality lying at the midpoint of a frequency distribution of observed values or quantities, such that there is an equal probability or falling or below it.

To calculate or Find median grou by in SQL Server click here Calculate median group by in SQL Server

For ex: supposed to find the median of bellows values like

{1,2,3,4,5} then the median is equal 3

{1,2,5,10} then the median is equal 3.5

{1,5,8,7} then median is equal 6

So how to calculate median in SQL Server query, below is the query to find the median

Query:

SELECT CONVERT(FLOAT,

(

(SELECT MAX(Score) FROM

(SELECT TOP 50 PERCENT Score FROM Demo ORDER BY Score ASC) AS BottomHalf))

+ CONVERT(FLOAT,

(SELECT MIN(Score) FROM

(SELECT TOP 50 PERCENT Score FROM Demo ORDER BY Score DESC) AS TopHalf)

) / 2) AS Median