← Mastercard questions
CodingReported in a candidate post, Oct 2024

Second highest salaried employee query

Filed under Mastercard

Given an Employee table with columns id, name and salary, write a SQL query that returns the second highest salary (and the employee holding it). Decide how ties and a missing second value should…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Mastercard questions

Collected from public candidate posts and coding forums. Updated Nov 2026.