How to select a record with a maximum value and a specific id in SQL?

Question

MySQL

How to solve this problem?

Answer 1

SELECT * FROM table WHERE group = 1 ORDER BY value DESC LIMIT 1