SQLite Exercise: Get 3 maximum salaries

Write a query to get 3 maximum 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
----------
24000
17000
14000

Practice SQLite Online

Model Database

Structure of 'hr' database :

Improve this sample solution and post your code through Disqus.

Previous: Write a query to list department number, name for all the departments in which there are no employees in the department.
Next: Write a query to get 3 minimum salaries.