SELECT TOP 50 PERCENT Views FROM Users ORDER BY Views; -...

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