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)


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