Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2

Question

2 years ago

8

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?

Computers and Technology

1 answer:

MariettaO [177] · Answer 1 · 2022-02-16T04:15:15+03:00

MariettaO [177]2 years ago

5 0

The result of MINUS operator will be 10 - 2 = 8 records (number of records in CUSTOMER - number of common records).