Salesforce Interview Question

Identify duplicates in a table, 2nd max salary