Infosys Interview Question

Write select query to find duplicate records.