Top Percentiles of users

Please login or register to vote for this query.

(click on this box to dismiss)

Calculates the percentiles of users by reputation, overall. The percentiles show the lower minimal value for each percentile. E.g. to be in the top 5% of users, you must have at least the reputation as shown in the p05 column. The p001 and p005 show the the top 0.1% and 0.5% of reputation.

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT PERCENTILE_CONT(0.01) WITHIN GROUP (ORDER BY reputation)   
OVER () TOP_1
from users

edited jun 19

created jun 19

anonymous

Enter Parameters

Options: Text-only results Include execution plan

Switch to main site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached