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
Thank you very much@Ignacio_Toledo !