select id, count(id)
from table
group by id

如果只想计数id，那么

If only want count of ids, then

select count(id)
from table
group by id

这是有关分组依据子句的简单教程

Here is a simple tutorial of group by clause

http://www.w3schools.com/sql/sql_groupby.asp