what is the difference between union and union all
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 are sql triggers used for?
How does cross join work?
What are the types of optimization?
What is the plv (pl/vision) package offers?
Are sql connections encrypted?
How do I get sql certification?
How to check if a column is nullable before setting to nullable?
What is a sql*loader control file?
How do you change a value in sql?
What is the difference between clustered and non-clustered index in sql?
What is sql stand for?
What is exit statement?
Explain the difference between triggers and constraints?
Explain what is table in a database?
How many types of primary keys are there?