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
);
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