Median Calculation on a Column in a Table

[sqls33ker]

Hi there,

I have the following code:

Select gender,
CASE
when gender = 'F' then 'Female'
when gender = 'M' then 'Male'
else 'Unknown'
end as test,
datediff(day, [tbl_record], getdate()) as 'datediffcal',
from [tbl_record]

I need to calculate a median on datediffcal column, but not sure how should the syntax goes.

It doesn't matter if the result shows only a median. For example, if it just shows:

median
15

that's fine. I just need to learn how the median calculation is done in T-SQL.

Any ideas?

[Rabbit]

Take the last record of the top 50 percentile and the first record of the bottom 50 percentile. Add them together and divide by 2. That will give you your median.

[sqls33ker]

I see.

I have seen some other posts that have similar answer. I will give it a try.

thank you