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

S

S

sandul232022-04-12 15:14:22

MySQL

sandul23, 2022-04-12 15:14:22

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

How to solve this problem?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Michael, 2022-04-12
@sandul23

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

Similar questions

E

Erl2017-10-26 12:36:26

How to make change for all elements? 4Reply

M

mumus2017-10-31 09:32:40

Change the contents of the waypoints of the Yandex Maps route? 1Reply

G

Gagatyn2017-11-13 01:09:19

How to store characters in an int array? 5Reply

M

mrWan2017-11-30 01:23:59

The strog tag which is inside the h1 overrides the h1 styles. How can this be fixed? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question