Salesforce interview question

Identify duplicates in a table, 2nd max salary