1Z0-051 QUESTION 17 NULL的运算_it generates an error because the usage of the rou-优快云博客

本文探讨了一个SQL查询案例，该查询旨在计算每位员工至今为止的总薪酬。通过使用日期运算、条件判断及字符串连接等功能，展示了如何构造复杂的SQL表达式来获取所需的数据。

QUESTION 17
View the E xhibitand examine the data in the EMPLOYEES table.
You want to generate areport showing the total compensation paid to each employee to date.
You issue the followingquery:
SQL>SELECT ename|| ' joined on ' || hiredate ||
', the totalcompensation paid is ' ||
TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365)* sal + comm)
"COMPENSATION UNTILDATE"
FROM emp;

What is the outcome?

A. It generates an error because the alias is not valid.
B. It executes successfully and gives the correct output.
C. It executes successfully but does not give the correct output.
D. It generates an error because the usage of the ROUND function in the expression is not valid.
E. It generates an error because the concatenation operator can be used to combine only two items.

答案：C

解析：

因为任何数值+NULL都为NULL，因此语句虽然能执行，但结果不对，选C

SQL> SELECT ename||  ' joined on ' || hiredate ||
  2  ', the totalcompensation paid is ' ||
  3  TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365)* sal + comm)
  4  "COMPENSATION UNTILDATE"
  5  FROM employees;

COMPENSATION UNTILDATE
-------------------------------------------------------------------------

SMITH joined on 17-DEC-80, the totalcompensation paid is
ALLEN joined on 20-FEB-81, the totalcompensation paid is 53100
WARD joined on 22-FEB-81, the totalcompensation paid is 41750
JONES joined on 02-APR-81, the totalcompensation paid is
MARTIN joined on 28-SEP-81, the totalcompensation paid is 42650
BLAKE joined on 01-MAY-81, the totalcompensation paid is

6 rows selected.