How to get row with maximum value of one field?

Question

SQL

I have a query that returns the following data:

ID	sum	UserID	TaskID
2700	98	2252	356
2701	100	2252	356
2702	100	2252	356
2703	56	2253	356
2704	100	2253	356

It is necessary to select from this request (by another request) for each UserID and TaskID the maximums in the Sum field and return the entire line (with ID). If there are equal amounts, then return the last one. The result should be a table like this:

ID	sum	UserID	TaskID
2702	100	2252	356
2704	100	2253	356

The query seems to be simple, but there were problems with choosing the correct ID (it's not a primary key, but just a column returned by another query) for the maximum amount - I can't seem to select the one that corresponds to the desired maximum amount.

Answer 1

Directly you will not establish in any way to which ID the specific maximum Sum belongs. At least if the request contains GROUP BY UserID, TaskID.