select (select count(*) from Users where reputation < 80...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
  --count(*) from Users where reputation < 800/count(*) from Users as percentile
  
    (select count(*) from Users where reputation < 800 ) as prcnt, 
    (select count(*) from Users) as total
   -- / count(*) from Users 
       --as "Percentage"

Enter Parameters

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