SQL query not showing all results when using Count

Question

I have a simple query that doesn't work on the server running MySql. All I want is for it to return a list of people and the number of times they appear in the table:

SELECT Person, Count(Person) as NoOfRecords FROM People;

This only returns one record and yet there are many. What am I missing? Thanks

Jason McCreary · Accepted Answer · 2013-06-12 20:21:16Z

5

Add a GROUP BY clause

SELECT Person, Count(Person) as NoOfRecords FROM People GROUP BY Person;

edited Jun 12, 2013 at 20:21

Jason McCreary

73.3k23 gold badges140 silver badges177 bronze badges

answered Jun 12, 2013 at 20:20

Bill Gregg

7,1572 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query not showing all results when using Count

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related