0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

--select COUNT(*) from Comments as comment_count
--where PostId = 123;

select top 1 UserId , count(*) as comment_count 
from Comments
group by UserId 
order by comment_count desc
;

fork query

edited dec 14

created dec 14 anonymous