How to manage Query with one data from multiple data

[achi]

I have data with the same data in each field but only diffrent number in the revision field.

I just want to show the last number in the revision field but the same data.

How to manage the quesry.

thanks