HomeworkLib
Question

What set operator would you use if you wanted to see all of the Customers and...

What set operator would you use if you wanted to see all of the Customers and the Employees including any records that may appear in both Customers and Employees?

select firstname
     , lastname
     , phone
from Customers

select firstname
     , lastname
     , phone
from Employees;

Group of answer choices

1 INTERSECT

2 EXCEPT

3 UNION ALL

4 UNION

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

3) UNION ALL

0 0
Add a comment
Know the answer?
Add Answer to:
What set operator would you use if you wanted to see all of the Customers and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • What is wrong with the following query? select firstname , lastname from Customer intersect select productid...

    What is wrong with the following query? select firstname , lastname from Customer intersect select productid , price , quantity from order_detail join orders on order_detail.orderid = orders.orderid; Group of answer choices 1 Nothing is wrong with this query 2 When working with set operators both queries have to contain the same number of columns. 3 The wrong set operator is being used. This query should use EXCEPT. 4 The wrong set operator is being used. This query should use...

  • Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName,...

    Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName, income, birthDate} Account = {accNumber, type, balance, branchNumberFK-Branch} Owns = {customerIDFK-Customer, accNumberFK-Account} Transactions = {transNumber, accNumberFK-Account, amount} Employee = {sin, firstName, lastName, salary, branchNumberFK-Branch} Branch = {branchNumber, branchName, managerSINFK-Employee, budget} Focus should be on using: Order By to sort data Set Operators to union/intersect multiple tables Join Operator to join multiple tables Aggregations and Group By to aggregate data Subqueries 3.8 SIN, first name,...

  • WHAT STATISTIC WOULD YOU USE IF YOU WANTED TO SEE IF THERE WAS A DIFFERENCE BETWEEN...

    WHAT STATISTIC WOULD YOU USE IF YOU WANTED TO SEE IF THERE WAS A DIFFERENCE BETWEEN THREE ETHNIC GROUPS ON MATH? EXPLAIN WHY

  • Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName,...

    Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName, income, birthDate} Account = {accNumber, type, balance, branchNumberFK-Branch} Owns = {customerIDFK-Customer, accNumberFK-Account} Transactions = {transNumber, accNumberFK-Account, amount} Employee = {sin, firstName, lastName, salary, branchNumberFK-Branch} Branch = {branchNumber, branchName, managerSINFK-Employee, budget} Focus should be on using: Order By to sort data Set Operators to union/intersect multiple tables Join Operator to join multiple tables Aggregations and Group By to aggregate data Subqueries 3.15 Customer ID, first...

  • As a manager of an organization, what probability distribution from this week would you use if you wanted to study one aspect of your annual employee turnover? Explain why you would use the probabilit...

    As a manager of an organization, what probability distribution from this week would you use if you wanted to study one aspect of your annual employee turnover? Explain why you would use the probability distribution to study the chosen aspect of employee turnover. In your post, be sure to identify the statistical formulas specifically and what additional data you would need to understand the chosen aspect of employee turnover. For example, some aspects of employee turnovers are employee age, years...

  • Since neither Lisa or Brad have a very high chance of winning, what would you set as a quota of n...

    Since neither Lisa or Brad have a very high chance of winning, what would you set as a quota of new customers if you wanted each of them to have at least a 25% chance of winning? Be sure to explain how you calculated your quota. Lisa Mendes and Brad Lee work in the sales department of an AT&T Wireless store. Lisa has been signing up an average of 48 new cell phone customers every month with a standard deviation...

  • Introduction In this lab, you will be working with three classes: Person, Student, and Roster. Person...

    Introduction In this lab, you will be working with three classes: Person, Student, and Roster. Person and Student represent individuals with a first and last name as String class variables, and Student has an additional int class variable that represents a ID number. The Roster class represents a group of people that are objects of either the Person or Student class. It contains an ArrayList. The Person class has been completed for you with class variables, a constructor, and a...

  • Which technique would you use if you wanted to < Identify all the regions of open...

    Which technique would you use if you wanted to < Identify all the regions of open chromatin in a particular cell type? Perform a paternity test? Amplify a specific sequence of DNA? [Choose] [Choose] Promoter fusion DNAse-seq Scanning mutagenesis Western blot RNAseq DNA fingerprinting Northern blot Reporter Assay DNAse footprinting ChIP-PCR EMSA Southern blot DNAse protection assay PCR BLAST search Protein fusion ChIP-seq [Choose Compare the global level of RNA expression between two samples? Detect presence of a specific protein...

  • HOMEWORK # 1 (for due date see web page) .You live in a city where all...

    HOMEWORK # 1 (for due date see web page) .You live in a city where all the people have the same preferences for food and these preferences are intransitive. You decide to open a restaurant and put several choices on the menu, but actually have only one dish in the kitchen (that saves you a lot in terms of costs!). You will change the available dish every day, but on any given day there is no real choice. Since your...

  • DESCRIPTION Create a C++ program to manage phone contacts. The program will allow the user to...

    DESCRIPTION Create a C++ program to manage phone contacts. The program will allow the user to add new phone contacts, display a list of all contacts, search for a specific contact by name, delete a specific contact. The program should provide the user with a console or command line choice menu about possible actions that they can perform. The choices should be the following: 1. Display list of all contacts. 2. Add a new contact. 3. Search for a contact...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT