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 is a database? : Sql dba
How do I view a procedure in sql?
Why truncate is faster than delete?
Why do we use view in sql?
How do we accept inputs from user during runtime?
Explain constraints in sql?
What are the ddl commands?
what is a unique key ? : Sql dba
State few characteristics of pl/sql?
Who is the owner of mysql database?
Explain the working of primary key?
What is difference between cursor and trigger?
Why we use stored procedure instead of query?
what is the difference between char_length and length? : Sql dba
Define concurrency control. : Transact sql