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 ORDER BY Reputation) AS bottomhalf)
 +
 (SELECT MIN(Reputation) FROM
   (SELECT TOP 50 PERCENT Reputation FROM Users ORDER BY Reputation DESC) AS tophalf)
) / 2 AS Median

fork query

created feb 25 anonymous