w3resource

SQLite Exercise: Find the 5th maximum salary in the employees table

Write a query to find the 5th maximum salary in the employees table.

Sample table : employees


SQLite Code:

SELECT DISTINCT salary 
FROM employees e1 
WHERE 5 = (SELECT COUNT(DISTINCT salary) 
FROM employees  e2 
WHERE e1.salary <= e2.salary);

Output:

salary
----------
13000

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 find the 5th maximum salary in the employees table.
Next: Write a query to find the 4th minimum salary in the employees table.

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