Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180507 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / sompalli krishna
Join: joins are used to combine the columns from one or
more tables(join using one table is possible for self
join).output should B more than one column.
It is constraint based.Columns r joined based on similar
column names and datatypes also on both the tables.
union: union is used to combine the columns from one or
more tables.Output should B one column.
It is not constraint based.Any no. of columns can be
combined without using any condition.But the data types
should be same immaterial to column names.
Contact me for any queries on 09885790989
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
What is input buffer in sql*plus?
What is string join?
How many joins can you have in sql?
How many disk partitions should I have?
What is a primary key example?
How do I kill a query in postgresql?
How to rename a column in the output of sql query?
Is sql open source?
What packages(if any) has oracle provided for use by developers?
Is sql workbench free?
What are different types of sql commands?
what is self join and what is the requirement of self join? : Sql dba
What is triggering circuit?
What is scope and visibility in PL/SQL?
how to create a new table by selecting rows from another table in mysql? : Sql dba
