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_foreachrow

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

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**