Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180597 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / rajan nadal
In join method join the two table by Atleast one row
match enough to join that tables
but in union
union can be combine the two select satement in the table
here the two select stament table having same number of
column and and datatype then only combine the two select
statement.here union display distinct values but union all
display all the values
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why indexing is needed?
What are all the ddl commands?
Explain the uses of database trigger.
Is sql open source?
What is sql partition function?
How do I create an index in word?
Can we create table in function?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is number function in sql?
what is a database transaction? : Sql dba
What are the disadvantages of not performing database normalization?
What is duration in sql profiler trace?
What do we need to check in database testing?
Which are the different case manipulation functions in sql?
What is the difference between Union and Union all. Which is faster.
