MVSFORUMS.com

[tattva]

Hi all,

i need to write a DB2 query which will fetch all the members whose :-

1) sum of three columns is zeroes

E.X :- Select all members where sum of ( column 1 + column 2 + colum3) = 0

Thanks,
Tattva

[kolusu]

tattva,

Try this

[tattva]

Hi Kolusu,

But this is taking a lot of time.

Let me mention here that primary key on the table are member, ssn and 3 more colums.

Thanks
Tattva

[kolusu]

tattva,

I am sorry for misunderstanding your Question. I re-read it once again and I am assuming that you have 5 colums say