Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181284 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / kamruddin saha
Join can be implemented different numbers of column where as
Union is implemented same number of column in different tables
Ex:- Table1 Contains 5 column and Table2 contains 8 columns.
So we can get data of 3 columns from Table1 and 4 Columns
from Table2 using JOIN.
But using UNION we can get same number of column from both
table.Like 2 columns from Table1 and 2 columns from Table2.
Thank You
| Is This Answer Correct ? | 13 Yes | 8 No |
Post New Answer View All Answers
Why stored procedure is better than query?
What packages(if any) has oracle provided for use by developers?
What is the use of sqldataadapter?
How much does sql certification cost?
What is pl/sql table? Why is it used?
What is primary key secondary key alternate key candidate key?
Why do we go for stored procedures?
how to fetch common records from two tables? : Sql dba
What is data definition language?
What are sql functions? Describe the different types of sql functions?
what are all the common sql function? : Sql dba
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Is sql easier than java?
How do I write a sql query in pgadmin 4?
When is the update_statistics command used?
