Re: How to calculate Median in a group of Data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 04/30/04


Date: Fri, 30 Apr 2004 13:48:40 -0400

http://groups.google.ca/groups?q=median+sql+group:microsoft.public.sqlserver.*&hl=en&lr=&ie=UTF-8&oe=UTF-8&scoring=d&selm=Or%23mzoUrDHA.2528%40TK2MSFTNGP12.phx.gbl&rnum=10

-- 
Tom
---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Reza Alirezaei" <anonymous@discussions.microsoft.com> wrote in message
news:uqmOImtLEHA.2396@TK2MSFTNGP12.phx.gbl...
I have got  a group of data like this
Row1     10
Row2      2
Row3      6
Row4      9
Row5     12
Row6      8
and I want to calculate median for it.
Thanks for your help.
Reza


Relevant Pages