Which Transact-SQL operator should you insert in line 03?

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?

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?

A.
UNION

B.
EXCEPT

C.
UNION ALL

D.
INTERSECT



Leave a Reply 0

Your email address will not be published. Required fields are marked *