SQL isolate greatest values in a column
I have the following output from a view:

    xfer_id  client_plt_id xfer_doc_no
    2255     80016616        KANORANJE1
    2270     80016616        ORANJECFC1
    2285     80016616        CFCFPT1
    2285     80016623        CFCFPT1
    2270     80016623        ORANCFC1
    2255     80016623        KANORANJE1
    2255     80016630        KANORANJE1
    2270     80016630        ORANCFC1
    2285     80016630        CFCFPT1

Where there is more than one client_plt_id with the same number I want to isolate the row with the highest xfer_id.

For client_plt_id = 80016616 that would be xfer_id = 2285 for example.

Any ideas on how I can do this?
SQL isolate greatest values in a column
===

I have the following output from a view:

    xfer_id  client_plt_id xfer_doc_no
    2255     80016616        KANORANJE1
    2270     80016616        ORANJECFC1
    2285     80016616        CFCFPT1
    2285     80016623        CFCFPT1
    2270     80016623        ORANCFC1
    2255     80016623        KANORANJE1
    2255     80016630        KANORANJE1
    2270     80016630        ORANCFC1
    2285     80016630        CFCFPT1

Where there is more than one client_plt_id with the same number I want to isolate the row with the highest xfer_id.

For client_plt_id = 80016616 that would be xfer_id = 2285 for example.

Any ideas on how I can do this?