I have file EMP: with ID,name,Department columns. Id as key field. There are more than a billion records with 50,000 duplicate records .I just want to fetch only those duplicate records on a single query.
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!