I have the following tables and columns:
If We join the tables, I get the following result set:
Asg.assignment_id sal.salary_amount. Sal. Sal_Start_date. sal.sal_end _date
1. 100. 2015-01-25. 2015-08-04
1. 150. 2015-08-05. 2015-08-09
1. 230. 2015-08-10. 2015-11-25
Question: I need to calculate the salary_increase for each row and display it in the calculated salary_increase.
The result should be added to the above result set (as a new calculated column within query) and values will be:
How can I write a query to compare the dates and calculate the increase????
Thanks in advance