搜索

考试

登录电脑网页、小程序享受畅享刷题等更多功能

Evaluate this SQL statement: SELECT ename, sal, 12...

CMS专题

单选题

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"?（）

发布日期：2020-04-10

A.No change is required to achieve the desired results.

B.SELECT ename, sal, 12*(sal+100) FROM emp;

C.SELECT ename, sal, (12*sal)+100 FROM emp;

D.SELECT ename, sal+100,*12 FROM emp;

标签： evaluate sql statement select ename

热门试题

热门资讯

暂无相关推荐~

分享给好友

分享到朋友圈

使用浏览器的分享功能，把这篇文章分享出去

确定