Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180602 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
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 are the types of queries in sql?
How do you optimize a query?
tell me about various levels of constraint. : Sql dba
Why is stored procedure faster than query?
Is a view faster than a stored procedure?
What is a natural join sql?
How do I run a pl sql program?
how to include numeric values in sql statements? : Sql dba
What is the difference between distinct and unique in sql?
How do I debug a stored procedure?
Explain mutating table error.
What is data control language?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
what is a control file ? : Sql dba
Explain the difference between drop and truncate commands in sql?
