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 show maximum salary from employee table?
Below is simple query to find the employee whose salary is highest. select *from employee where salary=(select Max(salary) from employee);
Read moreWho is the highest paid employee?
So, for those who say startups are the way, here are the world’s highest-paid employees.
Read moreWhat is the salary of an employee?
A salaried employee is a worker who is paid a fixed amount of money or compensation (also known as a salary) by an employer . For example, a salaried employee might earn $50,000 per year. Learn about what being a salaried employee entails, its pros and cons, and the difference between salaried and hourly employees.
Read moreHow is overtime calculated C++?
overtime = hours – 40 ; weeklywage = 40 * wage + overtime * 1.5 * wage; If there is no overtime, simply multiply the worked hours with the wage.
Read more