to get last six month sal update in six month

Question

Dear sir 

 

i have a salary field in my emp table  and  i want to get last six months salary then update in six month salary  in sql

 

 

need a sql query please