Hi,

We have retention policy , and pay at the time year completion , now policy change and it is converted from yearly to monthly and this with effect from April-15. 

if calculate the pay system will generate the Arrear payment of the employee from the month of April  onward but i already paid the retention amount for month for two month April and May which i need to deduct the same otherwise this will double amount  .

Can any body help me define in the Sql query.

Regards,

mis

Hi,

you have to post some test data and desired output.