max value without group by
420288Jan 27 2009 — edited Jan 27 2009I have data like the following, but cannot seem to get the maximum value from a row.
ID SCORE STATUS ATTRNO
12 989 ACTIVE 17
12 122 INACTIVE 17
33 1099 ACTIVE 17
I want to be able to pull out:
33 1099 ACTIVE 17
I cant do "group by" because it will return all the rows. Any guidance would be greatly appreciated.
Thanks!