SQL query help

Question posted by: ibmdb2user (Newbie) on August 19th, 2008 03:59 AM

Hello all,
I have a table and need to update the FINAL_FFE column based on the following.
FINAL_FFE is FFE divided by count of ASSIGN_ID's in the table.


ID ASSIGN_ID FFE FINAL_FFE

1 ABC123 1.0
1 ABC456 0.5
2 ABC789 0.5
3 ABC123 1.0
3 ABC456 0.5
3 ABC789 0.5
4 ABC123 1.0

After the update statement the table is expected to have the following.

ID ASSIGN_ID FFE FINAL_FFE

1 ABC123 1.0 .333
1 ABC456 0.5 .25
2 ABC789 0.5 .25
3 ABC123 1.0 .333
3 ABC456 0.5 .25
3 ABC789 0.5 .25
4 ABC123 1.0 .333

Thanks in advance.

Quote | Subscribe