How to identify Duplicates in a table using SQL PLUS
SELECT COUNT(*), COLUMN_A, COLUMN_BFROM TABLE_BGROUP BY COLUMN_A, COLUMN_BHAVING COUNT(*)>1;
Post a Comment
No comments:
Post a Comment