Re: Urgent -Dynamically calculating Quartiles

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 07/06/04


Date: Tue, 6 Jul 2004 10:57:45 +0100

If you Google the archives of this group you will find various solutions.
Since there are several possible varieties of Median you'll need to
expirment to see which meets your requirements. See also Celko's book, SQL
for Smarties, which has a chapter on Medians and also other statistics.

-- 
David Portas
SQL Server MVP
--


Relevant Pages

  • Re: Urgent -Dynamically calculating Quartiles
    ... "David Portas" wrote: ... > Since there are several possible varieties of Median you'll need to ... > expirment to see which meets your requirements. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Median Value
    ... Aaron Bertrand ... SQL Server MVP ... > A table has 100 records, field1 is numerical.field ... > I want get the median value. ...
    (microsoft.public.sqlserver.programming)