Get id and value of row with highest value

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.

Problem

Given 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.
Example input:
id | value
1  | 12
2  | 19
3  | 10
Example output:
id | value
2  | 19

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.
by sarastevens
SELECT id, value
FROM table
ORDER BY value DESC
LIMIT 1;

/*

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.

*/

A.I. Evaluation of the Solution

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