"Find the second or Nth highest salary" is probably the most asked SQL interview question. It tests whether you can handle ties and the case where no such row exists. Know at least two ways: DENSE_RANK for any N, and LIMIT with OFFSET on distinct salaries. Interviewers often follow up by asking what happens when two people share the top salary.