常用SQL之：统计重复数据的条数

select distinct id,name ,count(1)
from user1
group by id,name