2019-04-11
阅读量:
781
删除表中多余的重复记录(多个字段)
问题描述:
删除表中多余的重复记录(多个字段),只留有rowid最小的记录
解决方法:
delete 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条评论