DB重複資料 只留一筆

delete CIF_ORG_CUST_INFO where rowid in (
select rowid from  (
SELECT CIF_ORG_CUST_INFO.*,
           ROW_NUMBER() OVER (partition by DATA_SOURCE,CUST_CHT_NAME,CUST_ENG_NAME,CUST_ID,SESSION_DATE ORDER BY DATA_SOURCE,CUST_CHT_NAME,CUST_ENG_NAME,CUST_ID,SESSION_DATE) as seq
    FROM CIF_ORG_CUST_INFO
    ) a where a.seq = 1)


查詢重複最新的該筆
select ctb_ct_credit.* from ctb_ct_credit where rowid in (
select rowid from (
 SELECT ctb_ct_credit.*, ROW_NUMBER()
 OVER (partition by entity ORDER BY create_date desc) as seq FROM ctb_ct_credit ) a
where a.seq = 1)