3 Replies Latest reply on Aug 28, 2018 11:39 PM by meenu choudhary

    how to get eldest person from the family

    Satish G

      input data

      NAME,FNAME,DOB

      KAJAL,AGGARWAL,19-06-1985

      NISHA,AGGARWAL,18-10-1989

      KARISHMA,KAPOOR,25-06-1974

      KAREENA,KAPOOR,21-09-1980

      SONAM,KAPOOR,09-06-1985

      SHRADDHA,KAPOOR,03-03,1987

      SUMAN,SETTY,01-05-1971

      ANUSHKA,SETTY,07-11-1981

      SHILPA,SETTY,08-06-1975

      TWINKLE,KHANNA,29-12-1974

      RASHI,KHANNA,30-11-1990

      PRACHI,DESAI,12-09-1988

      RENU,DESAI,04-12-1981

      output data should be

      NAME,FNAME,DOB

      KAJAL,AGGARWAL,19-06-1985

      KARISHMA,KAPOOR,25-06-1974

      SUMAN,SETTY,01-05-1971

      TWINKLE,KHANNA,29-12-1974

      RENU,DESAI,04-12-1981

       

      the output should result the eldest person from the family(i.e family means fname and fname is same then they are same family)