Highest Manager Salary Query

EasySQL · PostgreSQL

Problem

Mphasis wants to review compensation levels in its delivery operations. Write a PostgreSQL query to identify the highest salary currently recorded for employees whose job title is exactly Manager.

Requirements

Filter employees to include only rows where job_title equals Manager.
Return the highest matching salary in a column named highest_manager_salary.
Use an aggregate function and do not return individual employee records.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's name
job_title	VARCHAR(50)	Employee's current job title
salary	NUMERIC(10,2)	Annual salary in INR

Tablesemployees

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.