Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag MEDIAN Rss

   Items 1 to 2 of 2   
 

Calculating the Median Value within a Partitioned Set Using T-SQL

It is ironic that one of the most essential of statistical aggregations, the median, has been so difficult in the past to calculate efficiently in SQL. Dwain Camps sets the candidates to work and identifies the winners and losers.   Read more...
By Additional Articles 2014/01/22 | Source: SimpleTalk | Category: median
Rating:  Rate this |   Briefcase | 2,603 reads

Median Workbench

SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why.  Read more...
By Additional Articles 2009/05/06 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,683 reads
   Items 1 to 2 of 2   
 
Tags
t-sql (2)    
aggregates (1)    
partition (1)