1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
WITCHER [35]
3 years ago
5

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?
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 AccountHolder
WHERE CityID <> SOME (SELECT CityID FROM BranchMaster)
D . SELECT AccountHolderID
FROM AccountHolder
WHERE CityID <> ANY (SELECT CityID FROM BranchMaster)
Computers and Technology
1 answer:
dusya [7]3 years ago
5 0

Answer:

A, B

Explanation:

A. selects accountholder's ids and check them with those who don't have cities in BranchMaster table.

B. We can use both <em>NOT IN</em><em> </em> as well as <> operator for comparison so it selects accountholder's ids which are not in all of those account holders who have cities in BranchMaster.

You might be interested in
What distinguishes Accenture’s Cloud capabilities from our competitors?
harina [27]

The things that differentiate Accenture’s Cloud capabilities from other competitors is allowing clients to choose the location, memory, and speed of the devices that they want to use.

Cloud computing refers to the delivery of several services through the internet. They're the tools and the applications like servers, databases, software, networking, etc.

Accenture’s Cloud capabilities are different from other competitors as it allows clients to choose the location and speed of the services that they want to enjoy.

Also, Accenture’s Cloud capabilities enable clients to host Cloud services using their own on-premise infrastructure.

Red related link on:

brainly.com/question/25557420

6 0
2 years ago
Can anyone answer this ​
Ivenika [448]

Answer:

I dont see the question

Explanation:

7 0
3 years ago
Plz go sub 2 "Shyy096" he is a 11 y/o boy and makes music fortnite vids, it would rly help him if u subscribe cuz he only has 8.
Pachacha [2.7K]

Answer:

OKK

Explanation:

5 0
3 years ago
Greg works for an online games development company. He is not a net freak, but occasionally he visits online literature sites an
sweet-ann [11.9K]

Answer:

i think its A

Explanation:i hope i helped

5 0
3 years ago
When you are driving on a rural road, if your right wheels run off the pavement, you should hold the steering wheel firmly and?
Lady_Fox [76]

When you are driving on a rural road, if your right wheels run off the pavement, you should hold the steering wheel firmly and such that it ought to be still with the bearing heading straight ahead and afterward while driving, it is ideal to back it off.    

Further Explanation:  

Rural Driving:  

Despite the fact that there is less traffic in rural zones those streets stay as hazardous as jam-packed thruways. There are some potential perils in country territories that you ought to know about: plain field and homestead garages and passages, animals crossing regions and ranch vehicles, harsh street conditions.  

Rural street:  

Rural streets are characterized as low traffic volume streets situated in forested and rangeland settings that serve private, recreational and asset the board employments. They may have been developed to moderately low measures with a restricted spending plan.  

Rural streets risky:

They additionally figure they can speed since, what are the chances of getting captured on a provincial street. Perilous Conditions – Because rustic streets are just two paths, it is risky to pass, the streets are typically smaller, and there is an expanded hazard for crashes that are head-on.  

Risky kind of street:  

Answer: Most individuals expect, on account of the high speeds included, that interstates or expressways are the most hazardous sort of street however they aren't. The most risky sort of streets for all drivers however particularly for youngsters are two-path nation or rustic streets  

Subject: Computers and technology

Level: High School

Keywords: Rural Driving, Rural street, Rural streets risky, Risky kind of street.

Related links:

Learn more about evolution on

brainly.com/question/2274303

brainly.com/question/10827308

8 0
3 years ago
Read 2 more answers
Other questions:
  • a reviewer is required to enter a reason in the comments field only when a candidate is recommended to be hired. which action ca
    8·1 answer
  • What is the advantage of using Mail Merge Wizard when creating a mail merge?
    12·2 answers
  • A​ _______ helps us understand the nature of the distribution of a data set.
    10·1 answer
  • 1. Caches are important to providing a high-performance memory hierarchy to processors. Below is a list of 32-bit memory address
    7·1 answer
  • Assume that the classes listed in the Java Quick Reference have been imported where appropriate.
    8·2 answers
  • Taking an online class doesn't require any special skills.
    13·2 answers
  • To display the Color gallery, with the graphic selected, click the Color button in the ____ group on the PICTURE TOOLS FORMAT ta
    14·1 answer
  • Why is lateral reading an important tool when reading material in social media or any online source
    15·1 answer
  • Tgif
    7·1 answer
  • One last question
    7·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!