Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181357 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 latest version of sql?
How insert into statements in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
Write a unique difference between a function and a stored procedure.
Can we use commit inside a trigger?
what happens if you no create privilege in a database? : Sql dba
Is pl sql better than sql?
Explain how to use transactions efficiently : transact sql
What is procedure explain with program?
what are different types of collation sensitivity? : Sql dba
How do I restart sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How would you convert date into julian date format?
tell us something about heap tables. : Sql dba
what is the difference between where clause and having clause? : Sql dba
