0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

SELECT UserId
FROM Comments
GROUP BY UserId
HAVING COUNT(*) = (
    SELECT MAX(CommentCount)
    FROM (SELECT COUNT(*) AS CommentCount FROM Comments GROUP BY UserId) AS Counts
) AND MAX(Id) IN (
    SELECT MAX(Id)
    FROM Comments
    GROUP BY UserId
    HAVING COUNT(*) = (
        SELECT MAX(CommentCount)
        FROM (SELECT COUNT(*) AS CommentCount FROM Comments GROUP BY UserId) AS Counts
    )
);

view current version

edited dec 11

created dec 11 jon.doe46559