A virtual data analyst job for students and freshers in India. Practise the work, not just the syntax.

Product

Scenario library
Pricing
How it works

For you

Students
Trainers & colleges
FAQ

Company

Contact
Institutions

© DataDesk. All companies, people and datasets are fictional.

Made for learners in India 🇮🇳

Nth highest with DENSE_RANK — practice · DataDesk

How it works
Scenarios
Practice
For trainers
Pricing

Log in Start free

Window functions: ranking(13 / 20)

Advanced Interview question

Nth highest with DENSE_RANK

Return the 4th highest distinct salary as fourth_highest using DENSE_RANK.

Tables

departments

dept_idinteger
dept_namevarchar
locationvarchar

emp_projects

emp_idinteger
project_idinteger
rolevarchar
hours_per_weekinteger

employees

emp_idinteger
first_namevarchar
last_namevarchar
emailvarchar
dept_idinteger
manager_idinteger
job_titlevarchar
salaryinteger
hire_datedate
cityvarchar
gendervarchar

projects

project_idinteger
project_namevarchar
dept_idinteger
budgetinteger
start_datedate
end_datedate

Expected output

1 row with column fourth_highest

Hints(0/2)

Solution

Unlocks after you solve it or after 3 submissions

SQL (DuckDB)

Ctrl + Enter to runLog in to save progress and earn XP

Run your code to see the output here.