Hello Experts,
I have a table with a column called Z_Status: the values of this column are DUP and Survivor, which means one of the record is Duplicate and another is survivor.
Now i have to update last Column called New_Account from Column C (EV870_ACCT_CODE), the New_Account Column should only be updated by the Max(EV870_ACCT_CODE) when grouping the information by Key2 Column.
I have shown the output and highlited the result in Green background (please check the attachment).
Apologize if i have not explained it well.
Waiting for the suggestions
Cheers