Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 181283 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
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
How does one load ebcdic data? : aql loader
What are the string functions in sql?
What is varchar used for?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what are the advantages a stored procedure? : Sql dba
What is cascade in sql?
What are the different types of dbmss?
What is rename in sql?
Show the two pl/sql cursor exceptions.
Explain alias in sql?
What is a temp table?
what is a composite primary key ? : Sql dba
What is difference between table and view?
What is db journal file?
