SQL查询重复记录，怎么写SQL。

id
A
B
B
C
C
A
A
D
要得到这样的

id 数量
A 3
B 2
C 2
D 1
怎么写啊？

select id, count(id) as 数量 from 表 group by id

SELECT id, COUNT(1) AS '数量' FROM 表 GROUP BY id ORDER BY COUNT(1) desc

select id,count(id) AS '数量' from '表名' group by id;

select id,count(id) AS '数量' from '表名' group by id;