Online Course Support

Which of these queries produces the same result set as the following query?

Question 2
Which of these queries produces the same result set as the following query?

SELECT * FROM table1

UNION

SELECT * FROM table2;

1 point

  • SELECT * FROM table1 UNION ALL SELECT * FROM table2
  • SELECT * FROM table1 UNION DISTINCT SELECT * FROM table2

Similar Posts