Organizational Research By

Surprising Reserch Topic

Question:Each employees salary must be increased by 10% and their commission by 20% of their newly increased salary. Display the new salary and commission plus each employee's total compensation. Evaluate the following SQL statements:


1.   SELECT sal * 1.1 "Salary", sal * 1.1 * .2 "Commission", sal * 1.1 + sal * 1.1 * .2 "Compensation"
      FROM    emp;
2.   SELECT sal * 1.1 "Salary", sal * 1.1 * .2 "Commission", (sal * 1.1) + (sal * .2) "Compensation"
      FROM    emp;
3.   SELECT sal * 1.1 "Salary", sal * .2 "Commission", sal * 1.1 + sal * 1.1 * .2 "Compensation"
      FROM    emp;
asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
174 views



Related Hot Questions



Government Jobs Opening


...