Nomura Interview Question

Find duplicate data in SQL; Java core concepts; Puzzle