删除数据库中重复记录的SQL语句
来源:互联网 发布:catia软件旋转快捷键 编辑:程序博客网 时间:2024/04/28 10:10
1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录
delete from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
and rowid not in (select min(rowid) from people group by peopleId having count(peopleId )>1)
3、查找表中多余的重复记录(多个字段)
select * from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
4、删除表中多余的重复记录(多个字段),只留有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)
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 (sel
- 找出数据库中重复记录的SQL语句并删除
- 删除数据库中重复记录的SQL语句
- 删除数据库中重复记录的SQL语句
- 删除数据库中重复记录的SQL语句
- 删除数据库中重复记录的SQL语句
- ----------删除数据库中重复记录的SQL语句(转)--------------------
- db2中删除重复记录的sql语句
- 去除数据库数据表中重复的记录的sql语句
- 几个删除重复记录的SQL语句!
- 几个删除重复记录的SQL语句
- 几个删除重复记录的SQL语句
- 几个删除重复记录的SQL语句
- 删除重复记录的sql语句
- 可以删除重复记录的SQL语句
- 几个删除重复记录的SQL语句
- 删除重复记录的SQL语句
- 几个删除重复记录的SQL语句
- 删除重复记录的SQL语句
- c常识
- Iptables模块recent应用
- jquery开发之代码风格
- 利用推特工具进行分词
- 安卓中的Model-View-Presenter模式介绍
- 删除数据库中重复记录的SQL语句
- openssl处理非阻塞socket
- Java项目如何记录日志
- 认识自己——人活着要做的第一件事
- JavaScript学习总结-技巧、实用函数、简洁方法、编程细节
- Android开发getCacheDir和getFilesDir区别
- java实现任意进制的互相转换
- JavaScript面向对象编程——构造函数继承
- 就地交换两个数的值