Snapdeal Interview Question

SQL query - Finding duplicate records