You administer a Microsoft SQL Server database that supports a banking

transaction management application.

You need to retrieve a list of account holders who live in cities that do not have a branch location.

Which Transact-SQL query or queries should you use? (Each correct answer presents a complete solution. Choose all t

hat apply.)

A.

SELECT AccountHolderID

FROM AccountHolder

WHERE CityID NOT IN (SELECT CityID FROM BranchMaster)

B.

SELECT AccountHolderID

FROM AccountHolder

WHERE CityID <> ALL (SELECT CityID FROM BranchMaster)

C.

SELECT AccountHolderID

FROM Ac

countHolder

WHERE CityID <> SOME (SELECT CityID FROM BranchMaster)

D.

SELECT AccountHolderID

FROM AccountHolder

WHERE CityID <> ANY (SELECT CityID FROM BranchMaster)

Reference: http://msdn.microsoft.com/en-us/library/ms188047.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms177682.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms173545.aspx