LuckyLucks
asked on
minium over 4 numeric columns for each row in oracle
Hi:
I need to get the minimum value across 4 columns for each row in a table. Pseudocode is like:
minimum (nvl(t.rating_A,0), nvl(t.rating_B,0), nvl(t.rating_C,0), nvl(t.rating_D,0)) as min_rating_over4cols_forea chrow
Is this possible with some sort of arithmetic function or something?
I need to get the minimum value across 4 columns for each row in a table. Pseudocode is like:
minimum (nvl(t.rating_A,0), nvl(t.rating_B,0), nvl(t.rating_C,0), nvl(t.rating_D,0)) as min_rating_over4cols_forea
Is this possible with some sort of arithmetic function or something?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.