SQL重复记录处理
来源:互联网 发布:超级玛丽mac版下载 编辑:程序博客网 时间:2024/06/10 07:43
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 ec_dnfhb where xh in (select min(xh) from ec_dnfhb group by ckhbm,cnpbm,cdayf having count(ckhbm)>1)
4、删除表中多余的重复记录(多个字段)
select * from ec_dnfhb where xh in (select min(xh) from ec_dnfhb group by ckhbm,cnpbm,cdayf having count(ckhbm)>1)
5、存贮过程解决
declare @max integer,@id integer
declare cur_rows cursor local for select 主字段,count(*) from 表名 group by 主字段 having count(*) >1
open cur_rows
fetch cur_rows into @id,@max
while @@fetch_status=0
begin
select @max = @max -1
set rowcount @max
delete from 表名 where 主字段 = @id
fetch cur_rows into @id,@max
end
close cur_rows
set rowcount 0
- SQL重复记录处理
- SQL重复记录处理
- SQL重复记录处理
- SQL重复记录处理
- SQL处理重复记录
- SQL查询重复处理记录
- pl/sql重复记录处理
- SQL Server中处理重复记录
- SQL重复记录处理(查找,过滤,删除)
- SQL重复记录处理(查找,过滤,删除)
- SQL重复记录处理(查找,过滤,删除)
- SQL重复记录处理(查找,过滤,删除)
- SQL重复记录处理(查找,过滤,删除)
- SQL的重复记录处理大全
- SQL重复记录处理(查找,过滤,删除)
- SQL重复记录处理(查找,过滤,删除)
- sql数据库对重复记录的处理
- SQL 重复记录问题的处理方法小结
- C# Panel 中加入 hScrollBar
- document.getElementById("radFs")对象为空,js判断对象是否存在?
- socket知识介绍
- 给网页赋值参考信息
- 男人拥有女人之后的几大心态
- SQL重复记录处理
- 自己看
- 速度奇慢的android模拟器
- 小主机开机启动-SVM file is missing.
- 聚沙成塔 - AEE_GET_X宏和AEE_GET_Y宏
- Unicode
- ASCII
- AppDomain,应用程序域 (转载)
- java Hack