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(Cnt)
    FROM (SELECT COUNT(*) AS Cnt FROM Comments GROUP BY UserId) AS SubQuery
) AND MAX(Id) = ANY (
    SELECT MAX(Id)
    FROM Comments
    GROUP BY UserId
);

view current version

edited dec 11

created dec 11 jon.doe46559