Infosys interview question

Write select query to find duplicate records.