138.Which statement is true regarding subqueries?

138.Which statement is true regarding subqueries?
A.The LIKE operator cannot be used with single-row subqueries.
B.The NOT IN operator is equivalent to IS NULL with single- row subqueries.
C.=ANY and =ALL operators have the same functionality in multiple- row subqueries.
D.The NOT operator can be used with IN, ANY, and ALL operators in multiple- row subqueries.
答案：D
解析：
A:错误 
B:错误,not in和is null就不是一回事
C:错误，=any 指的是只要有一个是相等的就可以，=all指的是必须都相等，一般不这样用
D:正确，这里如果不加其他操作符号 ，只有 not in，not any，not all的话，那肯定是错误的
这里必须增加其他运算符才行