How many posts have the exact same number of answers?

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT COUNT(AnswerCount)
                      FROM Posts
                      GROUP BY AnswerCount
                      HAVING COUNT(AnswerCount) >= 2;

edited oct 30 20

created oct 30 20

anonymous

Enter Parameters

Options: Text-only results Include execution plan

Switch to main site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached