What is the difference between join and union.
- 27 Answers
- 172832 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / nafisul haque
Join returns matching/non matching records as per condition
where as union returns union of recordsets. Join is used
within single select statement while union is used among
two or more select statements.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What do you mean by rowid?
How does a self join work?
What is an emotional trigger?
Why join is faster than subquery?
What is dialect in sql?
How many joins can you have in sql?
Explain the working of foreign key?
What is crud diagram?
What is difference between left and right outer join?
How do I count duplicates in sql?
What is the purpose of the primary key?
Why truncate is used in sql?
How do I debug a stored procedure?
What is trigger types in sql?
What is meant by <> in sql?
