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);






评论(0)


暂无数据
推荐帖子
0条评论
0条评论
1条评论