2 Replies Latest reply: Apr 10, 2018 4:24 PM by Sasidhar Parupudi RSS

    Need to display unique records based on key and date

    Akshaykumar Sharma

      Hi ,

       

      I have below table as sample data :

           

      CampaignIdCapaignNameStatusSentDateSentValue
      101ABCPending0
      101ABCSent09-04-2018540
      201XYZPending0
      301PQRSent09-04-20181020
      301PQRPending

      0

       

      I need ouput as below table :

       

           

      CampaignIdCapaignNameStatusSentDateSentValue
      101ABCSent09-04-2018540
      201XYZPending0
      301PQRSent09-04-20181020

       

       

      Thanks in advance,

      Akshay