Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 179546 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 sql query to display the current date?
Show how functions and procedures are called in a pl/sql block.
What is sqlerrd?
What is Histogram?
What is the syntax and use of the coalesce function?
What is data control language?
Can a table contain multiple foreign key’s?
What is self-join and what is the requirement of self-join?
Which command is used to delete a trigger?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Why are sql stored procedures used?
how many ways to get the current time? : Sql dba
Enlist the data types that can be used in pl/sql?
What is the difference between inner join and natural join?
What does fetching a cursor do?
