Register
Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains
124k views
4 votes
Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator?

User Roudi
by
5.9k points

1 Answer

5 votes
The result of MINUS operator will be 10 - 2 = 8 records (number of records in CUSTOMER - number of common records).
User Alfred Jingle
by
5.9k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

6.5m questions

8.7m answers

Other Questions

10 points Wireframing and storyboarding are helpful in which step of web development? Advertising Planning Printing Publishing
What is Blender's default save directory for movie AVI files?
If a website ends with .gov does it mean that its written by the government or?
To group option buttons so that selecting one deselects all of the others, you must make the ____ attribute the same.
How do I turn on your asus chromebook flip?
Link Copied!