Comment Score cumulative distribution

0

Please login or register to vote for this query.

(click on this box to dismiss)

How many comments do I have for each score.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
       CUME_DIST () OVER (PARTITION BY Score ORDER BY Score DESC) AS CumeDist,   
       PERCENT_RANK() OVER (PARTITION BY Score ORDER BY Score DESC) AS PctRank  
FROM comments

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results