Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180491 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / kamruddin saha
Join can be implemented different numbers of column where as
Union is implemented same number of column in different tables
Ex:- Table1 Contains 5 column and Table2 contains 8 columns.
So we can get data of 3 columns from Table1 and 4 Columns
from Table2 using JOIN.
But using UNION we can get same number of column from both
table.Like 2 columns from Table1 and 2 columns from Table2.
Thank You
| Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
What are procedures used for?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
Which is faster union or join?
Explain how exception handling is done in advance pl/sql?
Why use subqueries instead of joins?
what are different types of collation sensitivity? : Sql dba
Is big data nosql?
What sql does db2 use?
What is right join sql?
What is basic structure of pl sql?
What is scalar function?
what are integrity rules?
Can we create a trigger on view?
what is clause? : Sql dba
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
