Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 46341 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 a sql driver?
Why is %isopen always false for an implicit cursor?
What is a left inner join?
Can we use ddl commands in pl sql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is a variable in sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is the difference between function and procedure in pl/sql?
Why stored procedure is faster than query?
What is the use of pl/sql table?
Are sql database names case sensitive?
What are tuples in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
How many disk partitions should I have?
What is procedure and function?
