Capgemini interview question

SQL QURIES BASED ON DUPLICATES IN A TABLE.