PdfPrep.com

Which four Transact-SQL segments should you use to develop the solution?

DRAG DROP

A database contains tables as shown in the exhibit. (Click the Exhibit button.)

Products that are discontinued are moved from the Products table to the DiscontinuedProducts table. Any orders for discontinued products are removed from the Orders table. You write the following SELECT statement to return all the discontinued products: SELECT ProductId FROM DiscontinuedProducts You need to extend the SELECT statement to include products who do not have any orders.

Which four Transact-SQL segments should you use to develop the solution? To answer, move the

appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.

Answer:

Exit mobile version