'Display the job title concatenated with the max salary (separated by a : and space) and name the column "Job Salary Range". Use concat function

The HR department has requested a report of all jobs descriptions and max salaries. Display the job title concatenated with the max salary (separated by a : and space) and name the column "Job Salary Range". Use concat function

sql


Solution 1:[1]

Something like

SELECT CONCAT(job_title,' ',tot) FROM(
    SELECT
        job_title, max(salary) as tot
    FROM
        table
    GROUP BY
        job_title
) sub_query

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 JohanB

Related Questions