0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

WITH RankedUsers AS (
    SELECT UserID, COUNT(*) AS CommentCount, 
           ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) AS RowNum
    FROM Comments
    GROUP BY UserID
)
SELECT UserID
FROM RankedUsers
WHERE RowNum = 1;

view current version

edited dec 12

created dec 11 jon.doe46561