Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180492 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / lalitha
join:
The SQL JOIN clause is used whenever we have to select data
from 2 or more tables.
To be able to use SQL JOIN clause to extract data from 2
(or more) tables, we need a relationship between certain
columns in these tables.
union:
The purpose of the SQL UNION command is to combine the
results of two queries together. In this respect, UNION is
somewhat similar to JOIN in that they are both used to
related information from multiple tables. One restriction
of UNION is that all corresponding columns need to be of
the same data type. Also, when using UNION, only distinct
values are selected (similar to SELECT DISTINCT).
| Is This Answer Correct ? | 35 Yes | 11 No |
Post New Answer View All Answers
What is mdb stand for?
What is dense_rank?
How do I edit a trigger in sql developer?
What is native sql query?
how would you get the current date in mysql? : Sql dba
How do I run pl sql in sql developer?
Is join and inner join the same?
Is crud a cuss word?
Why use triggers in sql?
Is pl sql a programming language?
How to use sql*plus built-in timers?
Why use truncate instead of delete?
How are sql commands classified?
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 is sql and its types?
