StudentId Addpdr Subject GradeC ExamDate Marks 001 IN PHY X1 22/03/2017 73 001 PK CHE X11 02/03/2016 82 001 IN PHY X1 22/03/2017 62 001 IN PHY X1 10/11/2016 87 001 IN PHY X1 23/03/2017 92 001 PK CHE X11 10/03/2017 51 002 BN PHY X1 27/03/2017 62 002 BN PHY X11 02/03/2017 98 002 BN PHY X1 27/03/2017 34 002 BN PHY X1 27/03/2017 53 The desired output is: StudentId Addpdr GradeC Subject Marks 001 IN X1 PHY 135 001 PK X11 CHE 51 002 BN X1 PHY 149 002 BN X11 PHY 98 The Marks in the output is the addition of the marks if the latest exam date (with the combination of Studentid,Addpdr and GradeC) is repeating else the marks is the marks of the latest exam date for the combination of Studentid,Addpdr and GradeC.
... View more