Your question is Maximum Salary Query. 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.
Newgen Software is reviewing compensation data for employees supporting its OmniDocs platform. Write a PostgreSQL query to find the highest salary recorded in the employees table.
maximum_salary.The MAX aggregate function should evaluate all rows in the table. PostgreSQL automatically ignores NULL values during this aggregation. Do not return employee details or group the result by department.
| Column | Type | Description |
|---|---|---|
| employee_idPK | INTEGER | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| department | VARCHAR(80) | Employee's department |
| salary | NUMERIC(12,2) | Annual salary in the employee's local currency |