w3resource

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

Employee Model  Database - w3resource online SQLite practice

Structure of 'hr' database :

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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook