Improving the Row Numbering Median Solution

(Paul White) The fastest way to compute a median uses the SQL Server 2012 OFFSET extension to the ORDER BY clause. Running a close second, the next fastest solution uses a (possibly nested) dynamic cursor that works on all versions.

Read More - Register for Free Membership