查询数据库中重复的记录的SQL:

1.查询数据库中重复的记录:
select realname,count(*) from users group by realname having count(*)>1