How to count same values are exists in my record

Question

I have difficulty counting how many times a particular number appears in my table.

Let's say my table contains the following records:

number
 2
 4
 6
 2
 2
 4
 2

The following is what I want: If 2 exists 4 times, it should be counted and displayed along with 2 exists 4 exists 2 times and 6 exists 1 time.

Answer 1

Try this:

SELECT `number`, COUNT(*) as TotalRecords FROM records GROUP BY `number` ORDER BY `number` ASC

I hope this helps you.