Oracle 删除重复行-白红宇

Oracle 删除重复行

阅读量：5088 次

发布时间：2019-06-13

本文共 408 字，大约阅读时间需要 1 分钟。

DELETE FROM your_tableWHERE rowid not in(SELECT MIN(rowid)FROM your_tableGROUP BY column1, column2, column3);

删除表中多余的重复记录（多个字段），只留有rowid最小的记录

delete from vitae awhere (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)

转载于:https://www.cnblogs.com/flowerszhong/p/5075906.html

你可能感兴趣的文章

转:vs发布window应用程序时出错：未能签名 ...\setup.exe

查看>>

Spring Boot @ControllerAdvice 处理全局异常，返回固定格式Json

【bzoj2127】happiness 网络流最小割

查看>>

Windows中报错：Fatal error in launcher: Unable to create process using '"' 的解决方案

steps/train_lda_mllt.sh

COPY, RETAIN, ASSIGN , READONLY , READWRITE,STRONG,WEAK,NONATOMIC整理--转

查看>>

leetcode671- Second Minimum Node In a Binary Tree- easy

查看>>

LIS最长上升子序列O（nlogn)算法

查看>>