[单选]
The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25)
SALARY NUMBER (6,2)
COMMISSION_PCT NUMBER (6)
You need to write a query that will produce these results:
1.Display the salary multiplied by the commission_pct.
2.Exclude employees with a zero commission_pct.
3.Display a zero for employees with a null commission value.
Evaluate the SQL statement:
SELECT LAST_NAME, SALARY*COMMISSION_PCT
FROM EMPLOYEES
WHERE COMMISSION_PCT IS NOT NULL;
What does the statement provide?（）

A . all of the desired results
B . two of the desired results
C . one of the desired results
D . an error statement

《我爱祖国山水美》我们的祖国地大物搏，辐员辽阔，既有状丽的高山大川，又有宽广的草原海洋。泰山的岿然屹立，长江的浩浩汤汤，无不让人心弛神往，黄山的翻滚云海，黄河的怒吼湍流，无不让人叹为观止。每当面对祖国美丽的山水，谁不为之深情，谁不为之自豪呢！每当面对祖国宏伟的山水呵，我们火热的心情为你而激动，我们喜悦的泪水为你而抛洒。倘佯在祖国的山水中，我们的爱会油然而生，我们的情会与时递增。投入在祖国山水的怀抱中，我们更会情不自禁地大声宣告自己的心声，“我爱你，祖国美丽的山水！” 指出上文中存在的2处用词不当，并加以分析改正。合同与Y理论相对应的是“社会人”的假设。交流电动机调速方法中（）磁极对数越多，转速越高。磁极对数越少，转速越低。磁极对数越多，转速越低。磁极对数越少，转速不变。合同法

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25)
SALARY NUMBER (6,2)
COMMISSION_PCT NUMBER (6)
You need to write a query that will produce these results:
1.Display the salary multiplied by the commission_pct.
2.Exclude employees with a zero commission_pct.
3.Display a zero for employees with a null commission value.
Evaluate the SQL statement:
SELECT LAST_NAME, SALARY*COMMISSION_PCT
FROM EMPLOYEES
WHERE COMMISSION_PCT IS NOT NULL;
What does the statement provide?（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: