SQLite Exercise: Get 3 minimum salaries

Write a query to get 3 minimum salaries.

Sample table : employees

SQLite Code:

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

Output:

salary
----------
2400
2200
2100

Practice SQLite Online

Model Database

Structure of 'hr' database :

Improve this sample solution and post your code through Disqus.

Previous: Write a query to get 3 minimum salaries.
Next: Write a query to get nth max salaries of employees.