How is net salary calculated in SQL?

declare ename varchar2(15); basic number; da number; hra number; pf number; netsalary number; begin ename:=’&ename’; basic:=&basic; da:=basic * (30/100); hra:=basic * (10/100); if (basic < 8000) then pf:=basic * (8/100); elsif (basic >= 8000 and basic <= 16000) then pf:=basic * (10/100); end if; netsalary:=basic + da + …

Read more

How is net salary calculated in SQL?

declare ename varchar2(15); basic number; da number; hra number; pf number; netsalary number; begin ename:=’&ename’; basic:=&basic; da:=basic * (30/100); hra:=basic * (10/100); if (basic < 8000) then pf:=basic * (8/100); elsif (basic >= 8000 and basic <= 16000) then pf:=basic * (10/100); end if; netsalary:=basic + da + …

Read more

What is the salary of an employee?

A salaried employee is a worker who is paid a fixed amount of money or compensation (also known as a salary) by an employer . For example, a salaried employee might earn $50,000 per year. Learn about what being a salaried employee entails, its pros and cons, and the difference between salaried and hourly employees.

Read more