0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

SELECT
(
(SELECT MAX(Reputation) FROM
   (SELECT TOP 50 PERCENT Reputation FROM Users where Reputation > 1 ORDER BY Reputation ) AS bottomhalf)
 +
 (SELECT MIN(Reputation) FROM
   (SELECT TOP 50 PERCENT Reputation FROM Users where Reputation > 1 ORDER BY Reputation DESC ) AS tophalf)
) / 2 AS Median

fork query

created feb 25 George.Ruellan