SolarWinds Interview Question

Find the highest and second highest salaries by department from a table (SQL)