Posts with same number of Answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu Meta

Q&A about the site for Ubuntu users and developers

--SELECT COUNT(*) 'No of Rows'
--FROM (SELECT Count(P.AnswerCount) 'No Of Posts', P.AnswerCount
--FROM Posts AS P
--WHERE AnswerCount IS NOT NULL
--GROUP BY P.AnswerCount) AS TEMP;

SELECT Id, PostId 
FROM Comments
Where PostId in
(SELECT TOP 3 Count(PostId)
FROm Comments
WHere PostId is Not null
Group By PostId
Order by Count(PostId) DESC);

Enter Parameters

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