OK so I have looked theough the other solutions an no help. So here is what I am trying to do.
I need to select the row with multiple columns where the value in one column is the max value.

here is sample data

```
    orderfileid item number item cost   warehouse
    1           1234        3.45             ATL
    1           2345        1.67             DFW
    3           2345        2.45             NYY
    3           678         2.4              ORD
    2           1234        1.67             DFW

```

I need to select the entire row where the orderfileid is the max for each unique item number

the returned dataset should look like

```
    orderfileid item number item cost   warehouse
    2           1234        1.67             DFW
    3           2345        2.45             NYY
    3           6789        2.4              ORD

```

I think i tried every combination of select max(orderfileid) i can think of

Any help would be appriciated.
thanks