该博客讨论了在执行SQL查询时，当NULL值参与计算时如何导致错误的结果。在试图计算每位员工的总薪酬时，由于COMM列存在NULL值，查询虽然成功执行，但返回了一些不正确的总计，因为NULL与任何值相乘都会得到NULL。
一、原题
View the Exhibit and examine the data in the EMPLOYEES table.
You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:
SQL> SELECT ename||' joined on '||hiredate||
', the total compensation paid is '||
TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365) * sal + comm)
"COMPENSATION UNTIL DATE"
FROM employees;
What is the outcome?
A. It generates an error because the alias is not valid.
B. It execut
You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:
SQL> SELECT ename||' joined on '||hiredate||
', the total compensation paid is '||
TO_CHAR(ROUND(ROUND(SYSDATE-hiredate)/365) * sal + comm)
"COMPENSATION UNTIL DATE"
FROM employees;
What is the outcome?
A. It generates an error because the alias is not valid.
B. It execut
最低0.47元/天 解锁文章
1555
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
