I am listing database rows, and some could be duplicated with a newer version:
Col 1, Col 2, Col 3
124, 1, 0
124, 2, 0
124, 1, 1
124, 2, 1
I need to only keep the 2 last rows, which are the one with the Col3 being the maximum as it corresponds to a version number, and exclude the others.
Does anyone have an idea on how I can do this? I did look with Group By but I am not quote sure how to use it.