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 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 moreHow do you calculate total Employee pay?
Your total yearly take-home salary = gross salary – total deductions = ₹9.50 lakhs – ₹48,700 = ₹9,01,300. Now, your monthly take-home salary = annual salary/12 = ₹9,01,300/12 = ₹75,108. To do away with the tedious calculations, most people prefer the take-home salary calculator in India.
Read moreHow do you calculate total salary and wages?
Find your total gross earnings, before deductions, on your pay stub. Multiply this amount by the number of paychecks you receive each year to calculate your total annual salary . Suppose you are paid biweekly, and your total gross salary is $1,900. Calculate your annual salary with the equation $1,900 x 26 = $49,400.
Read more