SyntaxPilot
Courses/SQL and Databases/Lesson 79
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

SQL and Databases · Lesson 79 of 90

SQL interview 2: Nth highest salary and ranking puzzles

Nth highest salarysecond highest salaryLIMIT/OFFSET solutionDENSE_RANK solutioncorrelated-subquery solutionhandling ties and missing Nth valuerank within department

Detailed notes for this lesson are being written. They appear here together with the video.