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 net income from monthly salary?
Calculate for net pay Monthly, you make a gross pay of about $2,083. You determine that your monthly deductions amount to $700. To calculate your net pay, subtract $700 (your deductions) from your gross pay of $2,083. This would give you a monthly net pay of $1,383.
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 salary in python?
total gross pay = (hourly_wage *40) + (1.5 * hourly_wage * (worked_hours-40)) . if worked_hours < 40 then: total gross pay = hourly_wage *worked_hours.26 Kas 2020
Read more