(SELECT MAX(Views) FROM (SELECT TOP 50 PERCENT Views FRO...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English

Q&A for linguists, etymologists, and serious English language enthusiasts

-- SELECT
-- (
-- (SELECT MAX(Views) FROM
  -- (SELECT TOP 50 PERCENT Views FROM Users ORDER BY Views) AS BottomHalf)
-- +
-- (SELECT MIN(Views) FROM
--   (SELECT TOP 50 PERCENT Views FROM Users ORDER BY Views DESC) AS TopHalf)
--) / 2 AS Median

(SELECT MAX(Views) FROM
   (SELECT TOP 50 PERCENT Views FROM Users ORDER BY Views) AS BottomHalf)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results