Condition on duplicate values in a dataset

[jayanty]

Hi,

I have a dataset that looks like below.

Column-1          Rank

    row1               A

    row2               B

    row3               C

    row1               B

    row2               A

I am trying to achieve a dataset where only unique values of Column-1 are listed with considering only the highest rank record where A>B>C in ranking.

Like this:

Column-1          Rank

    row1               A

    row2               A

    row3               C

Any help is highly appreciated.

[LinusH]

select column_1, min(rank), as rank

from have

group by column_1

;

[jayanty]

Thank you LinusH. That works perfectly. I appreciate the quick response.