Snapdeal interview question

SQL query - Finding duplicate records