本文探讨了SQL中INTERSECT操作符的使用特点及注意事项。指出在使用INTERSECT时，所有SELECT语句中的列数和数据类型必须相同，这是正确使用该操作符的关键。此外还澄清了一些常见的误解。
Q62. Which statement is true regarding the INTERSECT operator?
A. It ignores NULL values.
B.The number of columns and data types must be identical for all SELECT statements in the query.
C. The names of columns in all SELECT statements must be identical.
D. Reversing the order of the intersected tables alters the result.
Correct Answer: B
Explanation/Reference:
References:
http://oraclexpert.com/using-the-set-operators/
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
