Top 1000 Answerers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

WITH TopAnswerers AS 
(
  SELECT
    OwnerUserId AS [User Link], 
    COUNT(*) AS AnswerCount
  FROM
    Posts
  WHERE
    PostTypeId = 2
    AND OwnerUserId IS NOT NULL
    GROUP BY OwnerUserId
)

SELECT 
  TOP 1000
    ROW_NUMBER() OVER(ORDER BY AnswerCount DESC) AS Position,  
    [User Link],
    AnswerCount
FROM TopAnswerers

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results