Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?
A) UNION
B) UNION ALL
C) INTERSECT
D) MINUS

Question

​Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?
A) ​UNION
B) ​UNION ALL
C) ​INTERSECT
D) ​MINUS

Quizplus · Accepted Answer

The UNION ALL operator combines the results of the SQL statements and includes duplicate rows. The UNION operator, on the other hand, discards duplicate rows. The INTERSECT and MINUS operators are used to perform set operations on two result sets and do not relate to the suppression of duplicate rows.

​Which of the Following Set Operators Will Display the Results

Which of the Following Set Operators Will Display the Results