Yes I have stored all the information about Employee including his basic salary in the sql database ,so if I update the basic salary of an employee,from 3000 to 5000 the it show in m y end of the year result that from this period to that period the basic salary was 3000 and now the salary is 5000?
How exactly can I do this ,do I have to write any specific sql query?