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!

HELP: SELECT MAX( Exp1, Exp2)

arronApr 23 2002

SELECT MAX( 1,2,3) FROM DUAL:
Should return 3 but it does not. Each element 1 2 3 is an expression. According to "Oracle 9i SQL Ref" MAX uses standard sql Expressions which Includes an Expression List which is delimited by "," Since SELECT MAX(2) FROM DUAL Returns 2 it should iterate.

I have a table
ID: VAL1: VAL2

I want to query and return 2 columns
ID: MAX(VAL1,VAL2)

I know I probably forgot something stupid.
Thank you for any help.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2002

Added on Apr 23 2002

2 comments

505 views