热线电话:13121318867

登录
2019-04-11 阅读量: 821
查找表中的重复记录(多个字段),不包含rowid最小的记录

问题描述:

查找表中多余的重复记录(多个字段),不包含rowid最小的记录

解决方法:

select * from vitae a 
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1) and rowid not in (select min(rowid) from vitae
group by peopleId,seq
having count(*)>1);
35.5375
3
关注作者
收藏
评论(0)

发表评论

暂无数据
推荐帖子