Getting a count of unique records in MYSQL

Question

I have a table in MYSQL, with the fields, id, size and color. An example of the data is

    ID      Size     Color
    0       34       Red
    1       34       Blue
    3       38       Green
    4       36       Yellow
    5       38       Red
    6       34       Red

Is there a way in mysql to get the number of all unique records in the table? I.E. There are 2 records that are size 34 and red. I want to pull out the count for all unique combinations in the table.

Alex Barnes · Accepted Answer · 2012-06-17 14:57:49Z

1

To get the count for each combination use

select size, color, count(*) from table group by size, color

answered Jun 17, 2012 at 14:57

Alex Barnes

7,2281 gold badge32 silver badges51 bronze badges

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

Comments

user1432124 · Accepted Answer · 2012-06-17 14:55:16Z

0

Thinking all id are unique.Try

Select size,color,count(*) from table group by size,color

answered Jun 17, 2012 at 14:55

user1432124

2 Comments

Alex Barnes Over a year ago

I was just looking at your answer thinking that it didn't work with the id in the distinct clase. Better after the edit!

Alex Barnes Over a year ago

Not really sure why you didn't accept the first correct answer but glad you got your answer in the end.

Collectives™ on Stack Overflow

Getting a count of unique records in MYSQL

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related