5th Highest Age with Window Functions | Dataford Interview Questions

How can I find the 5th highest age using dense rank and window functions with rank equal to 5?

Asked in the Interview stage. Use the employees table and return every employee whose age has a dense rank of 5.

Output

One row per matching employee, with employee_id, employee_name, age, and age_rank
Include all employees tied at the fifth-highest distinct age
Order by age descending, then employee_id ascending

employees

Your question is 5th Highest Age with Window Functions. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

How can I find the 5th highest age using dense rank and window functions with rank equal to 5?

Asked in the Interview stage. Use the employees table and return every employee whose age has a dense rank of 5.

One row per matching employee, with employee_id, employee_name, age, and age_rank
Include all employees tied at the fifth-highest distinct age
Order by age descending, then employee_id ascending

employees

Your question is 5th Highest Age with Window Functions. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.