0

Please login or register to vote for this query.

(click on this box to dismiss)

-- Who are the the 1% (Active Users)

Q&A for professional and enthusiast programmers

select DisplayName, Reputation
from
  (SELECT NTILE(100) OVER (ORDER BY Reputation DESC) as percentile, 
          DisplayName, Reputation
    FROM Users
    WHERE Reputation >= 200) as q
    where percentile <= ##SelectTopPercentile?1##

fork query

edited dec 5 12

created dec 5 12 davrob60