Cognizant interview question

write a sql query to check duplicates.