Cognizant Interview Question

write a sql query to check duplicates.