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
177 views



Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

...