What is the difference between a JOIN and a UNION in SQL?
- JOIN combines rows from two or more tables based on a related column
- JOIN is used for vertical merging
- UNION combines the results of two or more SELECT statements
- UNION is used for horizontal merging
In SQL, a JOIN combines rows from two or more tables based on a related column, while a UNION combines the results of two or more SELECT statements. JOIN operates vertically by merging rows, while UNION operates horizontally by combining result sets.
Loading...
Related Quiz
- What does the term "NoSQL" signify in database management?
- _______ preloading is a technique used to fetch critical resources in advance to reduce latency during page load.
- What is the primary function of Azure Blob Storage?
- What are the differences between the Observer and Publisher-Subscriber design patterns?
- Explain how Blue-Green Deployment works in a CI/CD pipeline and its advantages over traditional deployment methods.