SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, 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 | 3,842 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,960 reads
   Items 1 to 2 of 2   
aggregates (1)    
partition (1)