Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 47028 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
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How long it takes to learn pl sql?
What is sql procedures and functions?
What is foreign key in sql with example?
Why use stored procedures?
What do you mean by dbms? What are its different types?
Why partition by is used in sql?
what are all different types of collation sensitivity? : Sql dba
how to enter characters as hex numbers? : Sql dba
What is a table partition?
What is procedure in pl sql?
what are the advantages and disadvantages of views in a database? : Sql dba
does sql support programming? : Sql dba
What is form and report?
What are two statement types in sql?
