Problem

Given a table of data with employee IDs, names, and salary values, write a SQL query to find the highest paid employee.
Example input:
+----+----------+--------+
| ID | Name     | Salary |
+----+----------+--------+
| 1  | John     | 10000  |
| 2  | Jane     | 12000  |
| 3  | Smith    | 15000  |
| 4  | Mark     | 11000  |
+----+----------+--------+
Example output:
+----+----------+--------+
| ID | Name     | Salary |
+----+----------+--------+
| 3  | Smith    | 15000  |
+----+----------+--------+

Solution

SELECT * FROM table ORDER BY Salary DESC LIMIT 1;

/*

The solution above 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.

*/