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 final gross salary of an Employee using else if statement in C programming?
Logic to find gross salary of an employee
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 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