Wednesday, September 2, 2015

Deleting Duplicate Record In A Table

To delete duplicate records in a table use the below query:

delete /*+ PARALLEL(4) */ from letter_request A
WHERE a.rowid > 
   ANY (
     SELECT 
        B.rowid
     FROM 
        letter_request B
     WHERE 
      A.letter_name='WA20' and A.etl_batch_id=695
     AND
        A.loan_number = B.loan_number
     AND 
        A.sequence_number = B.sequence_number
        
     );

No comments:

Post a Comment