sql 删除重复行
来源:互联网 发布:淘宝介入怎么操作 编辑:程序博客网 时间:2024/06/01 11:34
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 peopleName in (select peopleName from people group by peopleName having count(peopleName) > 1)
and peopleId not in (select min(peopleId) from people group by peopleName having count(peopleName)>1)
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录
delete from people
where peopleName in (select peopleName from people group by peopleName having count(peopleName) > 1)
and peopleId not in (select min(peopleId) from people group by peopleName having count(peopleName)>1)
0 0
- 删除SQL重复行
- Sql删除重复行
- Sql删除重复行
- sql删除重复行
- sql 删除重复行
- Sql 删除重复行记录
- SQL如何删除重复行
- SQL查找删除重复行
- SQL查找删除重复行
- SQL查找删除重复行
- SQL查找删除重复行
- SQL SERVER删除重复行
- SQL查找删除重复行
- SQL查找删除重复行
- SQL查找删除重复行
- SQL查找删除重复行
- SQL查找删除重复行
- SQL查找删除重复行
- OpenCv中用hough变换检测直线,有图有真相
- hdu 2052 Picture
- python-pygame 安装
- 中国人的一天
- 第五周 课后实践:阅读程序(1)(2)(3)
- sql 删除重复行
- 解决android sdk 下载问题
- 八皇后问题,Java实现,可推广解决N皇后问题
- 【图说word】宏二
- 二维数组中的查找
- 实现购物车多物品数量 总价计算
- sql 内连接和外链接
- NYOJ 题目587 blockhouses(二分图最大匹配)
- crosses initialization of