Problem

Given a table of employee data, write a stored procedure that returns the name, job title, and salary of the employees with the highest salaries.
Example input:
Employee table:
+----+----------+-------------+---------+
| ID | Name     | Job Title   | Salary  |
+----+----------+-------------+---------+
| 1  | John Doe | Salesperson | 40000   |
| 2  | Jane Doe | Manager     | 80000   |
| 3  | Bill Doe | CEO         | 120000  |
+----+----------+-------------+---------+
Example output:
+----+----------+-------------+---------+
| ID | Name     | Job Title   | Salary  |
+----+----------+-------------+---------+
| 3  | Bill Doe | CEO         | 120000  |
+----+----------+-------------+---------+

Solution

/*

Solution:

SELECT * FROM Employee
ORDER BY Salary DESC
LIMIT 1;

This solution is optimal because it uses the ORDER BY and LIMIT clauses to sort the table by salary in descending order and then return the first row.

*/