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
SELECT MAX(salary) - MIN(salary) DIFFERENCE FROM employees;
DIFFERENCE ---------- 21900
Sqlite Online Editor
Structure of 'hr' database :
Improve this sample solution and post your code through Disqus.