Too many comments

Please login or register to vote for this query.

(click on this box to dismiss)

Display the top 50 posts with high total of comments

Q&A for Ubuntu users and developers

-- Too many comments
-- Display the top 50 posts with high total of comments

SELECT TOP 50 PostId as [Post Link], COUNT(Id) AS comments FROM Comments GROUP BY PostId ORDER BY comments DESC

created nov 30 10

Marco Ceppi

Enter Parameters

Options: Text-only results Include execution plan

Switch sites:

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached

Too many comments

Please login or register to vote for this query.

Enter Parameters

To avoid spam queries, all anonymous users must solve a captcha