This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both
result sets.
Instructions: Review the underlined text. If it makes the statement correct, select “No change is
needed.” If the statement is incorrect, select the answer choice that makes the statement correct
A.
No change is needed
B.
INTERSECT
C.
ALL
D.
UOIN
Correct Answer is C
0
4
B
3
0
right answer is B
0
0
A. No change is needed
The SQL UNION operator is used to combine the result sets of 2 or more SELECT statements. It removes duplicate rows between the various SELECT statements.
“Union All” returns all rows from both select statements.
1
1
have you a référence for your inswir plz
0
0
When used with two SELECT statements, the UNION set operator returns the results of both queries.However,if there are any duplicates, they are removed, and the duplicated record is listed only once.To include duplicates in the results,use the UNION ALL set operator.INTERSECT lists only records that are returned by both queries
1
0
SO, I believe it should be B.
INTERSECT lists only records that are returned by both queries
1
0
B. Intersect. Intersect is the same as inner join with distinct. An inner join or intersect is what the question describes.
0
0
The INTERSECT gives you the final result set where values in both of the queries match by
the query on both the left and right sides of the operand. ]
0
0