皮皮学，免费搜题
登录
搜题
【单选题】
客户需要计算EMP表中所有职工12*salary* commission_pct的值.EMP表结构如下：LAST NAME VARCNAR2（35）NOT NULL SALARY NUMBER（9，2）NOT NULL COMMISION_PCTNUMBER（4，2）哪个语句可以查询计算EMP表中所有职工行？（）A.
SELECT last_name，12*salary* commission_pct FROM emp
B.
SELECT last_name，12*salary*（commission_pct，0）FROM emp
C.
SELECT last_name，12*salary*（nvl（commission_pct，0））FROM emp如果oracle第一个参数为空那么显示第二个参数的值，如果第一个参数的值不为空，则显示第一个参数本来的值
D.
SELECT last_name，12*salary*（decode（commission_pct，0））FROM emp
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【简答题】Supposing we hold the meeting tomorrow, will there be enough time________ . (prepare) 2. Hurry up, there is no time_______ . (leave) 3. There are several children _________ (swim ) in the river. 4. Th...
【简答题】根据句意及首字母提示，补全句中所缺单词。 1. My new dress is s______ to the one you have. 2. Don't worry! I will explain my plan to you in d______ later. 3. How many s______ does the shepherd()look after? 4. We are taki...
【单选题】I don't like the way_____ you speak to your teacher.
A.
/
B.
in that
C.
which
D.
of which
【简答题】Facing the Enemies Within. I . Fear 1) Sources — You own (1) and information you get. — Some are (2) 2) Harm — Destroy ambitions, fortunes, (3) , even our lives. II. Indecision 1) The thief of (4)...
相关题目：
参考解析：
知识点：
题目纠错 0
发布
