w3resource
SQLite exercises

SQLite Exercise: Get the difference between the highest and lowest salaries

Write a query to get the difference between the highest and lowest salaries.

Sample table : employees


SQLite Code:

SELECT MAX(salary) - MIN(salary) DIFFERENCE
FROM employees;

Output:

DIFFERENCE
----------
21900

Sqlite Online Editor


Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.

Previous: Write a query to get the number of employees with the same job.
Next: Write a query to find the manager ID and the salary of the lowest-paid employee for that manager.

What is the difficulty level of this exercise?