Loading

add the bonus based on the employee salary

Manohar Gova

9y1.2k.NET

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.