contestada

Assume you are using the UNION operator to combine the results from two identical tables, 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. ____ records are returned when using the UNION operator.

Respuesta :

Seprum
The result of using UNION operator for these tables will have 10 + 7 - 2 = 15 records (number of records in CUSTOMER + number of records in CUSTOMER_2 - number of common records).

Otras preguntas