Question

What is the primary purpose of the UNION ALL operator in SQL?

A To combine the results of two or more queries, excluding duplicate rows from the final result.
B To combine the results of two or more queries, including all rows, even if they are duplicates.
C To update records in a table based on the results of multiple queries.
D To create a new table that contains the combined schema of two or more existing tables.
E To delete all records from multiple tables in a single operation.
Practice Next

Hey! Ask a query