Hi everyone,

I just wanted to know how to keep the max value per individual. I have this data:

id | months worked

1 | 20
1 | 24
2 | 15
2 | 40
3 | 10
4 | 5
5 | 5
5 | 10


So, I want to do something like this:


id | months worked

1 | 24
2 | 40
3 | 10
4 | 5
5 | 10


I hope you understand my idea. Thanks!!