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 moreWhat is flowchart and algorithm?
Algorithm and flowchart are the powerful tools for learning programming. An algorithm is a step-by-step analysis of the process, while a flowchart explains the steps of a program in a graphical way . Algorithm and flowcharts helps to clarify all the steps for solving the problem.
Read moreWhat is flowchart and algorithm?
Algorithm and flowchart are the powerful tools for learning programming. An algorithm is a step-by-step analysis of the process, while a flowchart explains the steps of a program in a graphical way . Algorithm and flowcharts helps to clarify all the steps for solving the problem.
Read moreWhat is the gross salary of an employee?
Gross salary is the monthly or yearly salary of an individual before any deductions are made from it . Components such as basic salary, house rent allowance, provident fund, leave travel allowance, medical allowance, Professional Tax etc. are some of the most prominent components of gross salary.
Read moreHow do you calculate an employee’s gross pay?
Example of gross pay for an hourly employee
Read more