Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

max value without group by

420288Jan 27 2009 — edited Jan 27 2009
I 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!
This post has been answered by Satyaki_De on Jan 27 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 24 2009
Added on Jan 27 2009
6 comments
5,670 views