Informatics Practices
What does UNION do ?
SQL Joins & Grouping
3 Likes
Answer
The SQL UNION operator is used to combine the results of two or more queries into a single result set. It removes duplicate rows from the final output.
Answered By
2 Likes
Related Questions
What is the difference between ON and USING join-clauses ?
A table STUDENT has 4 rows and 2 columns and another table TEACHER has 3 rows and 4 columns. How many rows and columns will be there if we obtain the Cartesian product of these two tables ?
Are UNION and UNION ALL the same ? Why ?
What does INTERSECT do ?