TableA
ID Value PerformedDtm
111 10 15/02/2008
121 15 15/02/2008
121 20 25/03/2008
131 20 09/12/2008
141 16 09/12/2008
131 18 25/12/2008
111 17 27/12/2008
121 16 29/12/2008
expected result:
ID Value PerformedDtm
111 17 27/12/2008
121 16 29/12/2008
131 18 25/12/2008
141 16 09/12/2008
Amit GuptaPosted Nov 15, 2018, 3:22 PM
Jignesh KumarPosted Nov 15, 2018, 11:31 PM