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 moreHow 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 moreHow do you calculate work per hour?
As you work during that length of time, hold on to all of the paychecks you earn. To get your hourly rate, divide the income you made in that period by how many hours you worked in that time . If you’re salaried, figure out roughly how many hours you work in a year, then divide your yearly salary by that number.
Read moreHow do you find the gross pay?
To calculate an employee’s gross pay, start by identifying the amount owed each pay period. Hourly employees multiply the total hours worked by the hourly rate plus overtime and premiums dispersed. Salary employees divide the annual salary by the number of pay periods each year . This number is the gross pay.
Read moreHow do you calculate net salary in C++?
Net Salary = Gross Salary – Deduction .17 Ara 2016
Read moreHow is net salary calculated in PL 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 moreWhat is added in gross salary?
Gross Salary is employee provident fund (EPF) and gratuity subtracted from the Cost to Company (CTC) . To put it in simpler terms, Gross Salary is the amount paid before deduction of taxes or other deductions and is inclusive of bonuses, over-time pay, holiday pay, and other differentials.
Read more