MySQL get distinct values and count how many of each?

Question

There is a status column. I need to pull all the distinct values for each one, and a number indicating how many times each unique value is in the table.

Is there a way to do that?

Thanks.

Rufinus · Accepted Answer · 2009-08-10 15:23:30Z

17

SELECT status, count(*) as c FROM table GROUP By status;

answered Aug 10, 2009 at 15:23

Rufinus

30.9k7 gold badges71 silver badges85 bronze badges

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

Comments

OneNerd · Accepted Answer · 2009-08-10 15:24:14Z

0

I am not sure I understand what you are after.

When you pull distinct values, there is (by definition) one of each unique value.

Can you rephrase what you are trying to do?

UPDATE

After reading another solution, I think I see what you are after.

Using SELECT COUNT(*) as given in the solution by Rufinus should do the trick.

answered Aug 10, 2009 at 15:24

OneNerd

6,57217 gold badges63 silver badges78 bronze badges

Collectives™ on Stack Overflow

MySQL get distinct values and count how many of each?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related