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 that 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 AccountHolderlD
FROM AccountHolder
WHERE CityID <> SOME (SELECT CityID FROM BranchMaster)
D.
SELECT AccountHolderID
FROM AccountHolder
WHERE CityID <> ANY (SELECT CityID FROM BranchMaster)
Explanation:
Verified the answers as correct.
http://msdn.microsoft.com/en-us/library/ms188047.aspx
http://msdn.microsoft.com/en-us/library/ms177682.aspx
http://msdn.microsoft.com/en-us/library/ms173545.aspx
ab
CD
AB. A and B are functionally equivalent. C and D are functionally equivalent. AB is correct because NOT IN and ALL will compare the complete list where C and D will not.
AB