Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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 !