9 Replies Latest reply: Jan 24, 2017 6:13 AM by sagar rahul RSS

    repeated data

    sagar rahul

      this is my table

            

      policy_noREGISTRATION_NUMSTART_DATEEND_DATEDATE_OF_LOSSresult
      2312200173578978UP-15-AR-246220-Dec-201119-Dec-201228-Dec-20112312200173578600
      2314200255005000UP-15-AR-246208-Jan-201307-Jan-2014 2314200255003700

       

       

      and below table is as my output

       

             

      policy_noREGISTRATION_NUMSTART_DATEEND_DATEDATE_OF_LOSSresultPOL_START_DATE
      2314200255005000UP-15-AR-246208-Jan-201307-Jan-201429-May-2012231420025500370008-Jan-2013

       

       

      how should i get my output :

       

      when  REGISTRATION_NUM is repeated two times but with two different policy as in first table

      then is should give result as shown in 2nd table

      then while giving output we should check that date of loss (as shown in bold ie "28-Dec-2011")of old or previous policy should be less than of START_DATE(as shown in bold ie '08-Jan-2013') new policy but it should have same REGISTRATION_NUM .

       

       

      i want in script form not in load form