You have two tables named Products and NewProducts that have identical structures. You have the following query (Line numbers are included for reference only):

01 SELECT Product, Description 02 FROM dbo.Products 03 ........ 04 SELECT Product, Description 05 FROM dbo.NewProducts You need to choose the appropriate Transact-SQL operator to display rows that exist in both tables. Which Transact-SQL operator should you insert in line 03?

Question

You have two tables named Products and NewProducts that have identical structures. You have the following query (Line numbers are included for reference only):

01 SELECT Product, Description 02 FROM dbo.Products 03 ........ 04 SELECT Product, Description 05 FROM dbo.NewProducts You need to choose the appropriate Transact-SQL operator to display rows that exist in both tables. Which Transact-SQL operator should you insert in line 03?

Accepted Answer

D. INTERSECT

Answer

A. UNION

Answer

B. EXCEPT

Answer

C. UNION ALL

You have two tables named Products and NewProducts that have identical structures. You have the following query (Line numbers are included for reference only): 01 SELECT Product, Description 02 FROM…

Question

Options

How the community answered

Community Discussion