Cognizant interview question

How to fetch Duplicate records using sql?