DELETE
FROM ESFRSLN_MIG M
WHERE M.ROWID IN ( SELECT T1.ROWID
FROM ESFRSLN_MIG T1
JOIN ESFRSLN_MIG T2 ON T2.KOR = T1.KOR
AND T2.ROWID < T1.ROWID
WHERE T1.KOR IN (SELECT KOR
FROM ESFRSLN_MIG
GROUP BY KOR
HAVING COUNT(*) > 1));
COMMIT;
중복건 제거 쿼리
|
2016.10.19 21:45:49
|
2016.10.19 21:46:01
|
389
|
Aiden
Total of Attached file
0.00 Bytes of 0 files
2018.08.06
2017.12.15
2017.09.07
2016.11.24
2016.10.20
2016.10.19
2016.09.21
2016.09.07
2016.07.07
2016.02.16
2016.02.13