Highest Salary Query

EasySQL · PostgreSQL

Problem

Persistent Systems needs a quick salary summary for its engineering workforce. Write a PostgreSQL query that returns the highest non-null salary recorded in the employees table.

Requirements

Return exactly one row containing the maximum value in salary.
Name the result column highest_salary.
Do not return employee details or calculate an average or total.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
name	VARCHAR(100)	Employee's full name
salary	NUMERIC(10,2)	Annual employee salary

Tablesemployees

CodePostgreSQL

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

Run your query to see results here.