Second-highest Salary

Interview Core Track · Hard · 35 min

Google wants a trend check for second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.

Interview Core Track

Hard

35 min

query basics

joins

aggregation

Company labels are directional practice context, not official interview guidance.

Timer 00:00

Practice query basics through a Google-tagged business scenario.

Use this track to improve speed, edge-case handling, and accuracy under timed conditions.

Company labels are directional practice context, not official interview guidance.

Prereq: query basics

Prereq: filtering

Google wants a trend check for second-highest salary. Return the second-highest salary amount in the table as second_highest_salary.

Pro question

Upgrade to Pro to unlock this prompt, the SQL workspace, and all 254 problems.

Editor

Run queries against the protected question data, then submit once the result shape looks right.

Create a free account or sign in before running queries against protected question data.