Hi Guys, I have a table and data like in the attached Input pic. If the table contains single id then directly we can consider that record. But the above table contains two ids with different effective dates. We have to consider the record that is having latest effective date among two ids and merge the remaining columns details for that row. Sample output: Attached Output pic Please help on this.