I have looked onto the web for finding duplicate records. However most the queries given finds one of the duplicate records.
Our requirement is to find both (or multiple) duplicate records from a table.
We are using Oracle 9i.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!