Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 46361 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
differentiate between float and double. : Sql dba
How do you pronounce sql?
Why is pl sql used?
What is procedure explain with example?
what is a relationship and what are they? : Sql dba
What is on delete set null?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What are different joins used in sql?
What problem one might face while writing log information to a data-base table in pl/sql?
What is pragma in pl sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
Which software is used for pl sql programming?
What is sequence in sql?
How to return multiple rows from the stored procedure?
Explain two easy sql optimizations.
