Select count(Id) CountID, AnswerCount Into #TEMPTABLE fro...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

Q&A about the site for scholars and enthusiasts of literature

Select count(Id) CountID, AnswerCount
Into #TEMPTABLE
from Posts
where AnswerCount is NOT NULL
group by AnswerCount
having count(Id) > 1
order by 2 DESC;

Select Count(Id) No_Of_Posts, AnswerCount
into #TEMP_TABLE
From Posts
where Answercount > 0
Group by AnswerCount
having count(Id) > 1
Order by 2

Enter Parameters

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