Max maharashtra salary - rs30000 ( MAX Sal – from excel lookup sheet )
Max Karnataka salary - rs10000 ( MAX Sal – from excel lookup sheet )
If employee have paid 35000 rupees in maharashtra then we create EMP with 30000 for Empid 100
If same employee move to next state Karnataka and kernataka max is 10000 then we should create Empid 100 = 0 as he have paid 30000 already in previous state which is greater than next state i.e NJ Max (10000)
So finally , Employee will have 2 records . 1st record for Empid 100 for maharashtra will have 30000 and 2nd Karnataka record will have 0
