add the bonus based on the employee salary

Question

Hi Guys,

 

i need to add the bonus amount of the employee based on employee salary in sql

 

Ex:  if Employee A is getting 10000 then i need to add 10% amount as bonus

       if Employee B is getting 20000 then i need  to add 20% amount as bonus

      if Employee C is getting 3000 then i need to add 30% amount as bonus 

 

EmpName  salary

A                  10000

B                  20000

C                  30000

D                  50000 

 F                  10000

 

A,F will get 10 % hike 

 

any sugestions 

 

Thanks in advance