Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181268 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
What is the requirement of self-join?
What is benefit of creating memory optimized table?
Why do we need sharding?
Is trigger a stored procedure?
Is truncate ddl or dml?
what is commit? : Sql dba
Can ddl statements be used in pl/sql?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What are the steps for performance tuning.
what is a relationship and what are they? : Sql dba
Which is faster view or stored procedure?
What is the difference between pl and sql?
Can a view be mutating? If yes, then how?
how can you create an empty table from an existing table? : Sql dba
Can we join tables without foreign key?
