首页计算机考试Oracle认证
(单选题)

Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?()

ANo change is required to achieve the desired results.

BSELECT ename, sal, 12*(sal+100) FROM emp;

CSELECT ename, sal, (12*sal)+100 FROM emp;

DSELECT ename, sal+100,*12 FROM emp;

正确答案

来源:www.examk.com

答案解析

快考试在线搜题