oracle 查询表重复数据 并 删除保留一条
摘要:
语法:select count(字段名),字段名 from 表名 group by 字段名 having count(字段名)>1 实例: select count(name),name from USER group by name having count(name)>1 在几千条记录里,存在着 阅读全文
posted @ 2017-07-19 10:14 零度千里 阅读(1465) 评论(0) 推荐(1) 编辑