MySQL count unique and duplicate values

Question

I need some help with counting both unique and duplicate values in MySQL. I want to know how many records there are total, and also how many is there two times and three times and so on...

Do I need to use UNION or something? I think SUM would be the best solution for me because of I might use some joins with this in future.

Sample data:

| custId | name   |
|--------|--------|
| 1001   | Alex   |
| 1001   | Alex   |
| 1002   | Daniel |
| 1003   | Mark   |
| 1002   | Daniel |

Sample results:

| total | twoTimes | threeTimes |
|-------|----------|------------|
|     3 |        2 |          0 |

Thanks in advance.

Answer 1

Just a basic group by should do it

    SELECT YourValue, Count(YourValue)
    FROM YourTable
    GROUP BY YourValue

If you want only a category, like unique values ADD

   HAVING Count(YourValue)  = 1