Solved programming problem

Show the 2nd highest salary range(max_salary-min_salary) job details from the jobs table

Source code

SELECT *

FROM jobs

ORDER BY (MAX_SALARY - MIN_SALARY) DESC

LIMIT 1,1;
Join the discussion

Add your comment