Skip to content
Advertisement

How to get the count of GROUP BY query?

How can I get the count of a GROUP BY SQL query?

This means I has displayed group by house number. I want the count of this group of house numbers.

Advertisement

Answer

This is only a guess, this would count number of voters per House No., like:

And if you want to include the YadiNo (whatever does this mean), you could do like this:

COUNT() is an aggregate function that normally is paired with GROUP BY clause.

See example here.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement