Top 3 Highest Paid Employees

EasySQL · PostgreSQL

Problem

Jio's workforce analytics team needs a simple report showing the three employees with the highest annual salaries. Write a PostgreSQL query using the employees table.

Requirements

Return the employee ID, employee name, and annual salary.
Sort employees from highest to lowest salary and return only the top three. Treat employees with NULL salaries as unranked, and use employee ID as a deterministic tie-breaker.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
annual_salary	DECIMAL(12,2)	Annual salary in Indian rupees
department	VARCHAR(80)	Employee's department

Tablesemployees

CodePostgreSQL

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

Run your query to see results here.