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 100
Id AS [User Link],
(SELECT COUNT(*)
FROM Posts
WHERE Posts.OwnerUserId = Users.Id
) AS [Total Posts]
FROM Users
ORDER BY [Total Posts] DESC

fork query

created sep 5 10 Peter Ajtai