Retrieve Employees With Highest Salary Records

Find all employees who have the highest salary.

sql

SELECT id, name, salary FROM employees WHERE salary = (SELECT MAX(salary) FROM employees);

This query retrieves the details of all employees whose salary matches the maximum salary value found in the "employees" table.

PromptDB can make mistakes. Please double-check responses.