问题:
Evaluate this SQL statement:
SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE
FROM employees e, sales s
WHERE e.employee_id = s.emp_id;
What will happen if you remove all the parentheses from the calculation? ()
A . The value displayed in the CALC_VALUE column will be lower.
B . The value displayed in the CALC_VALUE column will be higher.
C . There will be no difference in the value displayed in the CALC_VALUE column.
D . An error will be reported.
Evaluate this SQL statement:
SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE
FROM employees e, sales s
WHERE e.employee_id = s.emp_id;
What will happen if you remove all the parentheses from the calculation? ()
● 参考解析
本题暂无解析