0

Please login or register to vote for this query.

(click on this box to dismiss)

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;*/

fork query

edited jan 21

created jan 20 anonymous