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