Solved programming problem

Show the maximum and minimum value of min_salary column, maximum and minimum value of max_salary column from job_history table

Source code

SELECT MAX(MIN_SALARY) AS "Max of MIN_SALARY",

    MIN(MIN_SALARY) AS "Min of MIN_SALARY",

    MAX(MAX_SALARY) AS "Max of MAX_SALARY",

    MIN(MAX_SALARY) AS "Min of MAX_SALARY"

FROM jobs;
Join the discussion

Add your comment