JOIN versus UNION
QuizEasy-MediumAsked in: Accenture, TCS
Which describes the difference between a JOIN and a UNION?
- A JOIN puts columns from related rows of two tables side by side; a UNION stacks the rows of two queries with the same columns
- A JOIN removes duplicates; a UNION keeps them
- A UNION needs a matching key column; a JOIN does not
- They are two names for the same operation
This question is part of Pro+
Pro+ opens every question in Interview Prep and the mock interview. Every article and the first 2 questions of each topic stay free. Hands-on Selenium and API tasks follow their course lesson's own lock.