Find all employees who have the highest salary.
sqlCopySELECT id, name, salary FROM employees WHERE salary = (SELECT MAX(salary) FROM employees);
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.