To find the id and value of the row with the highest value in a table with two columns, id and value, write a query that will return the id and the value of the row with the highest value.
The solution above is optimal because it uses the ORDER BY and LIMIT clauses to sort the table by value in descending order and then return the first row.
Evaluated at: 2023-01-31 02:15:27