3rd Highest Salary SQL | Dataford Interview Questions

Write a query to find 3rd highest salary of employee having 'a' and 'c' in last name.

Asked in the Interview stage. Consider letters appearing anywhere in the last name, regardless of case. Treat the third-highest salary as the third distinct salary value.

Output

Return one row for each employee earning the third-highest qualifying salary.
Include employee_id, first_name, last_name, and salary.
Sort by last_name, then employee_id.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
first_name	VARCHAR(100)	Employee first name
last_name	VARCHAR(100)	Employee last name

employee_compensation

Column	Type	Description
employee_idPK	INT	Employee identifier referencing employees
salary	NUMERIC(10,2)	Current annual salary

Your question is 3rd Highest Salary SQL. Start with the requirements and the two tables 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