View questions sorted by answers count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

Select Top 100 p1.Id As [Post Link], Count(p2.Id) As AnswerCount
From Posts p1 Inner Join Posts p2 On p2.ParentId=p1.Id
Group By p1.Id
Order By AnswerCount Desc

Enter Parameters

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