Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 45828 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 auto increment?
What is the need of a partition key?
What is the difference between clustered and non-clustered indexes?
how to write date and time literals? : Sql dba
how to use in conditions? : Sql dba
How many types of keys are there in sql?
What is sql query optimization?
How do you optimize a stored procedure query?
What are the usages of sql?
What is the use of index in hive?
How do I count duplicates in sql?
Define a temp table?
What is the order of sql select?
Why is theta join required?
What is dml with example?
