This content has been marked as final. Show 9 replies
this is my table
and below table is as my output
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