Amazon Interview Question

Sql: Second Highest Salary, Find duplicate Entries