0 Replies Latest reply: Feb 3, 2017 8:32 AM by sagar rahul RSS

    compare 2 dif rows

    sagar rahul

      hii friends

       

      need a help from you

       

      this is my table     

       

      ENGINE_NUMDATE_OF_LOSSSTART_DATEPOL_NUM
      /1715612-Nov-201412-Oct-20142312200877894561
      /1715616-Aug-201123-Jul-20112312200107165498

       

       

       

      i table both of my ENGINE_NUM are same

      but its policy num are different of /17156

       

      and we have to compare  DATE_OF_LOSS with start date if ENGINE_NUM  are same as shown in above table 

      16-Aug-2011 is small than 12-Oct-2014

       

      if it satisfy then it should give its policy_num with its start date

       

      so output sholud be :

       

      ENGINE_NUMDATE_OF_LOSSSTART_DATEPOL_NUM
      /1715612-Nov-201412-Oct-20142312200877894561