2

Please login or register to vote for this query.

(click on this box to dismiss)

How many comments do I have for each score.

Q&A for pro webmasters

-- My Comment Score distribution
-- How many comments do I have for each score.


DECLARE @UserId int = ##UserId##

SELECT top 10
    Count(*) AS CommentCount,
    Comments.Score, Comments.PostId AS [Post Link], Text
FROM 
    Comments
WHERE 
    Comments.UserId = @UserId 
GROUP BY 
    Comments.Score, Comments.PostId, Text
ORDER BY 
    Comments.Score DESC

fork query

created jun 15 10 Mark Hurd