Retrieve row by maximum value

[Tib]

Hello,

I have a dataset containing sevral row like this :

id	vrs	data
0023387486	7335317	info1
0023387486	9487634	info2
0023387486	9000149	info3
0024084779	7405858	info4
0024084779	9633221	info5

I want to retrieve (filter) the row for each id where we have the greatest vrs value for this id, resulting in :

id	vrs	data
0023387486	9487634	info2
0024084779	9633221	info5

How can it be done ?

Thank you in advance,

Thibault

[Ignacio_Toledo · Accepted solution]

Hi @Tib 

Here is a video with one way of getting what you are looking for:

https://youtu.be/Ub6NxEYcigI

Hope this helps!

[Tib]

Thank you very much@Ignacio_Toledo !