T-SQL

External Article

Median Workbench

  • Article

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.

2009-05-06

2,024 reads

Blogs

Why use XACT_ABORT?

By

This came up one day at my work when a developer was using it....

Using AI for Data Conversion

By

I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...

Advice I Like: Tipping

By

When in doubt, overtip – from Excellent Advice for Living This is close to...

Read the latest Blogs

Forums

Installing SQL Instance on a Clustered Virtual Disk

By bokswager

Hi Everyone, I have a question, I am trying to setup a Lab environment...

Upgrades to SQL Server 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Upgrades to SQL Server 2022

Elements of the SQL Server Update Statement

By Kenneth Igiri

Comments posted to this topic are about the item Elements of the SQL Server...

Visit the forum

Question of the Day

Upgrades to SQL Server 2022

What is the earliest version from which you can directly upgrade to SQL Server 2022?

See possible answers