0

Please login or register to vote for this query.

(click on this box to dismiss)

Perguntas e respostas para programadores profissionais e entusiastas

--SELECT COUNT(*) 'No of Rows'
--FROM (SELECT Count(P.AnswerCount) 'No Of Posts', P.AnswerCount
--FROM Posts AS P
--WHERE AnswerCount IS NOT NULL
--GROUP BY P.AnswerCount) AS TEMP;

SELECT TOP 3 PostId, Id
FROM Comments
WHere PostId is Not null
Group By PostId, Id
Order by Count(PostId) DESC;

fork query

edited sep 28 20

created sep 28 20 anonymous