Highest Salary and Ranking | Dataford Interview Questions

Meesho's People Analytics team needs a quick view of the maximum salary currently recorded in its employee dataset. Write a PostgreSQL query that returns the highest salary value from the employees table.

Requirements

Return one row containing the highest non-NULL salary.
Name the result column highest_salary.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(50)	Employee's department
salary	NUMERIC(12,2)	Annual salary in Indian rupees

Your question is Highest Salary and Ranking. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Requirements

Return one row containing the highest non-NULL salary.
Name the result column highest_salary.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(50)	Employee's department
salary	NUMERIC(12,2)	Annual salary in Indian rupees

Your question is Highest Salary and Ranking. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.