What is the difference between join and union.
Answer Posted / viswanath
Both of them are two different operations, but both are
used for merging. However, UNION used for Vertical merge
where as JOIN used for Horizontal merge.
We can never use these two distinct operations
interchengably.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a sql profiler?
Are sql connections encrypted?
Why is theta join required?
explain commit and rollback in mysql : sql dba
Explain the significance of the & and && operators in pl sql.
What does dml mean?
How do you delete data from a table?
What are the different schemas objects that can be created using pl/sql?
Which certification is best for sql?
What is a sql trace file?
What does subquery mean in sql?
How do I find duplicates in a single column in sql?
what is sql profiler? : Sql dba
What are pl sql procedures?
Can we write dml inside a function in sql server?