SELECT name, salary
FROM employees
WHERE position ='manager'ORDERBY salary DESCLIMIT1;
This query selects the name and salary of the employee with the highest salary from the "employees" table, filtered by the "manager" position, and returns the top record.
PromptDB can make mistakes. Please double-check responses.