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
B
right answer is B
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.
have you a référence for your inswir plz
B. Intersect. Intersect is the same as inner join with distinct. An inner join or intersect is what the question describes.