Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 46574 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
What is the purpose of the sql select top clause?
what is datawarehouse? : Sql dba
What does stand for in sql?
What is the difference between join and natural join?
State few characteristics of pl/sql?
How do you write an inner join query?
Which type of cursor is used to execute the dml statement?
Can instead of triggers be used to fire once for each statement on a view?
What are aggregate functions in sql?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What does the hierarchical profiler does?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
define sql update statement ? : Sql dba
What is output spooling in sql*plus?
What is data types in sql?
