Function to Calculate Median in SQL Server

by

If you’re using SQL 2005 or better this is a nice, simple-ish median calculation for a single column in a table:

SELECT
(
 (SELECT MAX(Score) FROM
   (SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score) AS BottomHalf)
 +
 (SELECT MIN(Score) FROM
   (SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score DESC) AS TopHalf)
) / 2 AS Median

More Related Contents:

  1. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  2. SQL Server: Difference between PARTITION BY and GROUP BY
  3. Check if table exists in SQL Server
  4. Using T-SQL, return nth delimited element from a string
  5. What is the use of GO in SQL Server Management Studio & Transact SQL?
  6. SELECT DISTINCT on one column
  7. Using a if condition in an insert SQL Server
  8. Altering a column: null to not null
  9. best way to convert and validate a date string
  10. Confused about UPDLOCK, HOLDLOCK
  11. TSQL Email Validation (without regex)
  12. Dynamic SQL results into temp table in SQL Stored procedure
  13. SQL Server Output Clause into a scalar variable
  14. TSQL: Create a view that accesses multiple databases
  15. TABLOCK vs TABLOCKX
  16. How to convert number of minutes to hh:mm format in TSQL?
  17. How do I select last 5 rows in a table without sorting?
  18. How to change default language for SQL Server?
  19. SELECT INTO a table variable in T-SQL
  20. T-SQL query to show table definition?
  21. How can I insert binary file data into a binary SQL field using a simple insert statement?
  22. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  23. Include missing months in Group By query
  24. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”
  25. SQL SERVER – Understanding how MIN(text) works
  26. Pivot multiple columns based on one column in SQL Server
  27. @@ERROR and/or TRY – CATCH
  28. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  29. How to calculate difference in hours (decimal) between two dates in SQL Server?
  30. Cannot delete rows from a temporal history table

Leave a Comment