id列重复
select count(id),name
from table
group by id having count(id)>1
id列和name列都重复
select count(id),name
from table
group by id,name having count(id)>1
id列重复
select count(id),name
from table
group by id having count(id)>1
id列和name列都重复
select count(id),name
from table
group by id,name having count(id)>1