sql语句删除重复
来源:互联网 发布:java bufferstring 编辑:程序博客网 时间:2024/06/05 09:43
用SQL语句,删除掉重复项只保留一条 在几千条记录里,存在着些相同的记录,如何能用SQL语句,删除掉重复的呢
1、查找表中多余的重复记录,重复记录是根据单个字段(trans_id)来判断
select * from intf_task_instance t where t.trans_id in (select trans_id from intf_task_instance group by (trans_id, intf_task_instance_id) having count(trans_id) > 1);
2、删除表中多余的重复记录,重复记录是根据单个字段(intf_task_instance_id)来判断,只留有rowid最小的记录
delete from intf_task_instance t where t.intf_task_instance_id in (select intf_task_instance_id from intf_task_instance group by intf_task_instance_id having count(intf_task_instance_id) > 1) and rowid not in (select min(Rowid) from intf_task_instance group by intf_task_instance_id having count(intf_task_instance_id) > 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)
5、查找表中多余的重复记录(多个字段),不包含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
- sql语句删除重复
- Sql语句--删除重复列
- sql语句删除重复记录
- sql删除重复记录语句
- SQL语句删除重复记录
- SQL语句删除重复记录
- SQL语句删除重复记录
- sql语句删除重复数据
- sql语句删除重复行
- SQL 语句删除access重复记录语句
- 几个删除重复记录的SQL语句!
- sql中删除部分重复的语句
- 几个删除重复记录的SQL语句
- SQL语句快速删除重复记录
- 一题多解教你SQL语句删除重复记录
- SQL语句删除表中重复字段
- SQL语句删除表中重复字段
- 几个删除重复记录的SQL语句
- adb 连不上设备
- 深度学习实践操作—从小白到大白(一):Ubuntu系统U盘安装
- CCF分蛋糕
- mac 设置 launchpad 展示方式
- Mapreduce工作机制(一)框架
- sql语句删除重复
- javascript 如何判断比较当天24小时的时间大小
- C函数中的memcpy的用法(本文为转载!!!)
- 如何基于Redis Replication设计并实现Redis-replicator?
- Java环境配置的常见问题汇总
- Javascript基础应用
- Django小开发《采用验证码的注册页代码》
- 阿了嗝欢的小白日记——HashMap(上)
- chasing实习总结