Third Highest Salary Window Function | Dataford Interview Questions

Sql Snowflake Pyspark Zero copy cloning in snowflake Third highest salary sql question using window function

Write a SQL query to return the third highest distinct salary from the employee salary data. If fewer than three distinct salaries exist, return no row.

Output

One row at most
Column: third_highest_salary
Include only the third highest distinct salary value, not employee details
If there are ties at the third rank, return that salary once

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
department	VARCHAR(100)	Employee department
salary	NUMERIC(12,2)	Employee salary

Your question is Third Highest Salary Window Function. 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.

Problem