query 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

--select * from posts where commentCount>150
--select max(commentCount) from posts 
--select answerCount from posts group by answercount
--having count(AnswerCount) >1
--select distinct answercount from posts 
--where answercount in ()

--select count(answerCount) from posts 
--where answerCount in (select distinct answercount from posts)

SELECT answerCount,
       count(*) AS c
FROM posts
GROUP BY answerCount
--HAVING c > 1
ORDER BY c DESC

Enter Parameters

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