SELECT t2.Id, t.CID, t.AnswerCount FROM ( SELECT AnswerCo...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

SELECT t2.Id, t.CID, t.AnswerCount FROM (
  SELECT AnswerCount, COUNT(Id) CID FROM Posts
  GROUP BY AnswerCount
  HAVING COUNT(Id) > 1) t
  JOIN
  Posts t2
  ON t.AnswerCount = t2.AnswerCount
  ORDER BY t.CID DESC;
/*select TOP(3) Id, SUM(CommentCount) AS CommentCount FROM Posts
GROUP BY Id
ORDER BY CommentCount DESC;*/

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results