Help with SQL Server 2008 query

Question

Hi

I have this table:

id name
1  A
1  B
2  C
2  D
2  E
3  F

and I need to get this:

id qty
1  2
2  2
3  1

Answer 1

SELECT id, COUNT(name) AS qty
FROM tablename
GROUP BY id
ORDER BY id

But that would return

id qty
1 2
2 *3*
3 1

Not sure if that is a typo.