Regarding the DB2

yarapatineni · #1 (**permalink**) 12-11-07, 04:57

Hi all,,

i want to know something about the case statement

supoose i have 10,432,456,32221,345 in this i want to find the max value using the case statement

if anybody have idea about this please let me know

Thanks,
satya

r937 · #2 (**permalink**) 12-11-07, 06:53

answer: normalize your data, then use this --[code]select max(foo) from daTable[/b]

yarapatineni · #3 (**permalink**) 12-11-07, 07:37

Hi r,

max funtion gives the max value of the prticular column.

suppose i have 4 columns like

no1, no2,no3,no4
12 13 14 10
14 243 321 45

these are all the columns.. i want to find the max of the no1,no2,no3 and no4
the result is like this 14 and 321

thanks
satya

r937 · #4 (**permalink**) 12-11-07, 07:49

my answer is still the same -- normalize your table

stolze · #5 (**permalink**) 12-11-07, 09:33

Or in other words: why do you want to find the maximum of values with completely different semantics?

jsharon1248 · #6 (**permalink**) 12-11-07, 10:21

You don't mention which version of DB2 you are using. DB2 for z/OS supports the MAX scalar function, so it would just be

Code:

SELECT max(col1,col2,col3)
  FROM <table>
 WHERE <predicates>

UDB for AIX does not support the MAX scalar function. I don't know about other versions.

Internet Services

Web Development

Digital Marketing

Consumer Tech