|
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.
| 
