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

0

Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

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 

Select count(No_of_posts)
From #TEMP_TABLE

Enter Parameters

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