MySQL Subquery Exercises: Query to get 3 minimum salaries

MySQL Subquery: Exercise-21 with Solution

Write a query to get 3 minimum salaries.

Sample table: employees

Code:

SELECT DISTINCT salary 
FROM employees a 
WHERE  3 >= (SELECT COUNT(DISTINCT salary) 
FROM employees b 
WHERE b.salary <= a.salary) 
ORDER BY a.salary DESC;

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 maximum salaries.
Next:Write a query to get nth maximum salaries of employees.