摘要:
一 获取重复的数据的值select user_name from usersgroup by user_namehaving(count(1)>1)二 获取重复数据的记录select * from users where user_name in( select user_name from users group by user_name having(count(1)>1))三查找表中多余的重复记录(多个字段)select * from vitae where (a.peopleId,a.seq) in (select peopleId,seq from vitae gro.. 阅读全文