0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description
SELECT TOP 10
    U.id AS [User Link]
FROM
    Users U
    JOIN 
       (SELECT OwnerUserId, Cnt = Count(*)
       FROM POSTS
       WHERE PostTypeId = 2
       GROUP BY OwnerUserId) A
    ON U.id = A.OwnerUserId
    GROUP BY U.id

fork query

created sep 6 10 Peter Ajtai