Capgemini Interview Question

SQL QURIES BASED ON DUPLICATES IN A TABLE.