Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 179573 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 commit? : Sql dba
What is record type in pl sql?
What is difference between left and right outer join?
What are inner and outer joins examples of both?
How do I create an index in word?
what is 'trigger' in sql? : Sql dba
What are the syntax and use of the coalesce function?
how to escape special characters in sql statements? : Sql dba
What is a recursive stored procedure?
How do I view a sql database?
What are the different types of a subquery?
What is pessimistic concurrency control? : Transact sql
what is user defined functions? : Sql dba
What is materialized view in sql?
How to call shell script from pl sql procedure?
