← Morgan Stanley questions

Nth highest salary and max salary per day

Filed under Morgan Stanley

Given a table of name, salary and date, write SQL for the nth highest salary and for the maximum salary on each day, and explain joins.

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 Morgan Stanley questions

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