热线电话:13121318867

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

问题描述:

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

解决方法:

update vitae set ispass=-1 
where peopleId in (select peopleId from vitae group by peopleId,seq having count(*) > 1) and seq in (select 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.0000
1
关注作者
收藏
评论(0)

发表评论

暂无数据
推荐帖子