Theodore Theodore - 2 years ago 55
C# Question

How to count the same name inside a column?

link This is my column showing the name of the president the user voted, I need to count these names in order to show the result of the election. How do I count it using select count() and group by?

Answer Source

The following SQL should do the trick.

SELECT President, COUNT(*)
FROM tbl_voter
GROUP BY President
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download