Which Transact- SQL query or queries should you use?

You administer a Microsoft SQL Server database thatsupports a shopping application. You need to retrieve a
list of customers who live in territories that do not have a sales person. Which Transact- SQL query or queries
should you use? (Each correct answer presents a complete solution. Choose all that apply.)

You administer a Microsoft SQL Server database thatsupports a shopping application. You need to retrieve a
list of customers who live in territories that do not have a sales person. Which Transact- SQL query or queries
should you use? (Each correct answer presents a complete solution. Choose all that apply.)

A.
SELECT CustomerID FROM Customer
WHERE TerritoryID <> SOME(SELECT TerritoryID FROM Salesperson)

B.
SELECT CustomerID FROM Customer
WHERE TerritoryID <> ALL(SELECT TerritoryID FROM Salesperson)

C.
SELECT CustomerID FROM Customer
WHERE TerritoryID <> ANY(SELECT TerritoryID FROM Salesperson)

D.
SELECT CustomerID FROM Customer
WHERE TerritoryID NOT IN(SELECT TerritoryID FROM Salesperson)

Explanation:
Verified answer as correct.



Leave a Reply 1

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


Mohamed

Mohamed

Answer B,D