Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181271 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / mohan
join is used to combine two different tables where as in union
union also perform the same operation but the difference is
union will return distinct(unique) values.we can eliminate
the duplicate records while using union
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Which table is left in join?
What is a recursive stored procedure?
What is case function?
How do you create a unique index?
Where can I learn sql for free?
what is bdb (berkeleydb)? : Sql dba
What are the usages of sql?
What is denormalization in a database?
What is the difference between join and natural join?
What is package in pl sql?
What is the use of desc in sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
State some properties of relational databases?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
how mysql optimizes distinct? : Sql dba
