Who are the 1%? (Active Users)

0

Please login or register to vote for this query.

(click on this box to dismiss)

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

Stack Overflow

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##

Enter Parameters

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