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!

maximum of two values in a single Query

862489May 24 2011 — edited May 24 2011
Table Name M M
Table column at_mdb_curr_domainb/c bcom_mdb__curr_domainb/c
Criteria max value for a day among domain B and C max value for a day among domain B and C


I have a table M where in columns at_mdb_curr_domainb,at_mdb_curr_domainc,bcom_mdb__curr_domainb,bcom_mdb__curr_domainc
are present. I want to have maximum values between columns at_mdb_curr_domainb,at_mdb_curr_domainc as one resul i.e(at_mdb_curr_domainb/c)

Then max values of bcom_mdb__curr_domainb,bcom_mdb__curr_domainc as another result(bcom_mdb__curr_domainb/c) in a single Query..

Pls could you suggest how this can be achieved.

Many thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 21 2011
Added on May 24 2011
1 comment
3,373 views