Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 47035 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / leena
union all will combine the outputs of two or more queries.
union will combine the outputs of two or more queries but remove or ignore duplicate value in output.
union all is most faster as compare to union
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How is sql used in oracle?
How do I make my sql query run faster?
Why join is faster than subquery?
Is a foreign key always unique?
What is coalesce in sql?
Mention what pl/sql package consists of?
What is sorting in sql?
Can we create a trigger on view?
What are the operators in sql?
What is the difference between row level and statement level trigger?
What is ttitle and btitle?
What are the different types of sql commands?
What is raw datatype in sql?
What is substitution variable?
what are sequences
