3 Replies Latest reply: Oct 1, 2015 5:05 PM by Sudhanshu Shrivas RSS

    Need Unique data

    Sudhanshu Shrivas

      I have a table where I have code number ,location ,region ,zone ,amount and date field.

      Code no repeats ,

      I want to have sum of amount with unique code no in a table and that should be at max of date.

       

      Eg:

       

      If code no 1235 is coming two times in a table and have two dates and two amounts associated then I want

      Code no 1235 only for once in a table with sum of both amount associated with it and the date associated should be the max date.

       

      Please help

       

      Thanks