SELECT TOP 1 Posts.Id , COUNT(PostHistory.Id) FROM Posts ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

SELECT TOP 1
  Posts.Id
  , COUNT(PostHistory.Id)
FROM 
  Posts
  INNER JOIN PostHistory ON Posts.ID = PostHistory.PostID
GROUP BY
  Posts.Id
ORDER BY 
  COUNT(PostHistory.Id) DESC;

Enter Parameters

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