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!

select column_name with highest value in table

3728May 1 2007 — edited May 1 2007

Hello,
I have a table with many ( 30 ) numeric columns.
I need to get the column_name in the table that has the highest value. I also need the column_name with the second highest value.
My attemps have gone nowhere ( using greatest to get value, and try to join with cols ).
Any help is appreciated.
Take care.
S

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2007

Added on May 1 2007

5 comments

1,118 views