(152)Which statement is true regarding the UNION operator?
A. By default, the output is not sorted.
B. NULL values are not ignored during duplicate checking.
C. Names of all columns must be identical across all SELECT statements.
D. The number of columns selected in all SELECT statements need not be the same.
答案:(B)
解析:
Union和union all的区别有二:是否消除重复的行;是否进行排序(前者进行排序)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1171411/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1171411/