maximum of two values in a single Query
862489May 24 2011 — edited May 24 2011Table 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