Pregunta de entrevista de Amazon

Sql: Second Highest Salary, Find duplicate Entries