Find Highest Salary in Employees Table

Find the employee with the highest salary.

sql

SELECT * FROM employees ORDER BY salary DESC LIMIT 1;

This query sorts the "employees" table by the "salary" column in descending order and returns the first record, effectively identifying the employee with the highest salary.

PromptDB can make mistakes. Please double-check responses.