本文详细解析了SQL查询中遇到子查询返回NULL值时的不同处理方式及输出结果，通过具体示例帮助理解NULL值在SQL查询中的影响。
146. Evaluate the following SQL statement:
SQL> SELECT cust_id, cust_last_name
FROM customers
WHERE cust_credit_limit IN
(select cust_credit_limit
FROM customers
WHERE cust_city ='Singapore');
Which statement is true regarding the above query if one of the values generated by the subquery is
NULL?
A. It produces an error.
B. It executes but returns no rows.
C. It generates output for NULL as well as the other values produced by the subquery.
D. It ignores the NULL value and generates output for the other values produced by the subquery.
Answer: C
答案解析：
这道题的意思是说：如果子查询出现的值是null会怎样？
1、首先运行子查询里面的sql语句，结果为null
sh@TEST0910> select cust_credit_limit
2 FROM customers
3 WHERE cust_city ='Singapore';
no rows selected
2、如果子查询为null，那么结果也为null。
sh@TEST0910> SELECT cust_id, cust_last_name FROM customers WHERE cust_credit_limit IN
2 (select cust_credit_limit FROM customers WHERE cust_city ='Singapore');
no rows selected
扫一扫
274
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
