MySQL Subquery Exercises: Query to get nth maximum salaries of employees

MySQL Subquery: Exercise-22 with Solution

Write a query to get nth maximum salaries of employees.

Sample table: employees

Code:

SELECT *
FROM employees emp1
WHERE (1) = (
SELECT COUNT(DISTINCT(emp2.salary))
FROM employees emp2
WHERE emp2.salary > emp1.salary);

Explanation:

MySQL Subquery Syntax:

- The subquery (inner query) executes once before the main query (outer query) executes.
- The main query (outer query) use the subquery result.

MySQL Code Editor:

Structure of 'hr' database:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to get 3 minimum salaries.
Next:MySQL Joins