SQL: count of replica entries in a column

Question

Simplistically I have a table that looks like this:

ColA | ColB |
-----+------+
EE34 | Woo  |
ER56 | fro  |
EE34 | eco  |
QW34 | Sddg |
EE34 | zoo  |
ER56 | safe |

I need a select statement for SQL Server that produces:

ColA | Count |
-----+-------+
EE34 | 3     |
ER56 | 2     |
QW34 | 1     |

This could be running over a table with 100k+ records.

Answer 1

SELECT  ColA, COUNT(*)
FROM    mytable
GROUP BY
        ColA

Or I am missing something?