Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 46559 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / praveen k. agrawal
union is used For select distinct values from two tables
where as union all is used For select all values including
duplicates from the tables.
For Example Table X contain values(a,b,c) and Table Y
contain values(c,d,e)
In Case Of Union we will get Result-a,b,c,d,e
and other hand (Union All ) we will get-a,b,c,c,d,e.
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
What is the difference between the conventional and direct path loads? : aql loader
Is primary key is clustered index?
What packages are available to pl/sql developers?
What is meant by temporal data?
What are the triggers associated with image items?
How to get list of all tables from a database?
Can a view be mutating? If yes, then how?
What is query syntax?
What language is oracle sql developer?
What is the difference between a subquery and a join?
what are the differences between char and varchar? : Sql dba
Where do we use pl sql?
Explain architecture of sql server notification services?
How to call shell script from pl sql procedure?
How do you optimize a query?
