单选题EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12*salary*（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。A 12000B 0C 2400D NULL

题目

单选题

EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12*salary*（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。

12000

2400

NULL

更多“单选题EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12salary（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。A 12000B 0C 2400D NULL”相关问题

第1题

在Oracle中，下面哪条语句当COMM字段为空时显示0，不为空时显示COMM的值（）。A、select ename,nvl（comm.,0）from empB、select ename,null（comm.,0）from empC、SELECT ename,NULLIF（comm,0）FROM empD、SELECT ename,DECODE（comm.,NULL,0）FROM emp

点击查看答案
第2题

EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12*salary*（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。A、12000B、0C、2400D、NULL

点击查看答案
第3题

下面哪条语句可以取出薪水最高的前三个人：（）A、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；B、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM<=3；C、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM<=3；D、SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC；

点击查看答案
第4题

The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）A、SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;B、SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;C、SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;D、SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;

点击查看答案
第5题

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 resultsB、Two of the desired resultsC、One of the desired resultsD、An error statement

点击查看答案
第6题

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）A、SELECT ename, salary*12 'Annual Salary' FROM employees;B、SELECT ename, salary*12 "Annual Salary" FROM employees;C、SELECT ename, salary*12 AS Annual Salary FROM employees;D、SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees

点击查看答案
第7题

Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);C、SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);D、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);E、SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

点击查看答案

单选题EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12*salary*（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。A 12000B 0C 2400D NULL

题目

更多“单选题EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12*salary*（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。A 12000B 0C 2400D NULL”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容

单选题EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12salary（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。A 12000B 0C 2400D NULL

更多“单选题EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12salary（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。A 12000B 0C 2400D NULL”相关问题