select TOP 1 c.PostId as Post_Id , count(*) as Comment_Co...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Great Outdoors

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

select TOP 1 c.PostId as Post_Id ,
count(*) as Comment_Count
from Posts p join Comments c on
c.PostId = p.Id 
group by c.PostId 
order by 2 desc

Enter Parameters

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