Your question is SQL Query for Top Salaries. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
The Allscripts people operations team wants to identify employees with the highest recorded salary. Write a PostgreSQL query using the employees table to return all employees tied for the highest salary.
NULL and return exactly one result row.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| department | VARCHAR(80) | Allscripts department |
| salary | NUMERIC(10,2) | Annual salary in USD |