14 Replies Latest reply: Mar 17, 2016 5:38 AM by kushal chawda RSS

    Get max record of the each ID

    sunil kumar

      HI all ,

      Please help me to get output table based on inpt table below

      Input table

      ID,Prodcut,Rowno

      1,A,1

      1,A,2

      2,B,1

      3,C,1

      4,D,1

      4,D,2

      4,D,3

      5,E,1

       

       

      Get latest rowno of the each ID below likw this

      for

      output:

      ID,Product,Rowno

      1,A,2

      2,B,1

      3,C,1

      4,D,3

      5,E,1