DELETE FROM 테이블명
WHERE ROWID IN (
SELECT ROWID FROM (
SELECT * FROM (
SELECT ROW_NUMBER() OVER(PARTITION BY 컬럼명 ORDER BY 컬럼명) AS num
FROM 테이블명
)
WHERE num > 1 (-> num의 값이 1초과인 데이터들만 삭제)
)
);
출처: https://rahm.tistory.com/52 [RAHM]
SELECT ROWID FROM (
SELECT * FROM (
SELECT ROW_NUMBER() OVER(PARTITION BY billindex ORDER BY billindex) AS num
FROM billinfo_detail
)
WHERE num > 1
);
