How to calculate Median in SQL Server

Posted by Jeff Smith on August 30, 2010

Nothing earth-shattering here, I was just helping out a colleague with this so I thought I'd post up the example I gave him.


-- sample table:
create table People
(

 
 
  Person varchar(1) primary key,

 
 
  City varchar(10),

 
 
  Age int
)

go

-- with some sample data:

insert into People
select 'A','Boston',23... [read more]

Rating

not rated

Reviews

There are currently no comments or reviews.

Submit a review:

Login required.