what is the difference between union and union all
- 14 Answers
- 43847 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / suresh
union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables
| Is This Answer Correct ? | 175 Yes | 12 No |
Post New Answer View All Answers
What are some predefined exceptions in pl/sql?
What do you mean by “trigger” in sql?
Define commit, rollback and savepoint?
What is an exception in pl/sql?
What is sql query limit?
Does sql support programming?
what are enums used for in mysql? : Sql dba
What is sql select statement?
What is record variable?
What is difference between mysql and postgresql?
Why having clause is used in sql?
Is coalesce faster than isnull?
What is a relationship and what are they?
How does left join work in sql?
How will you distinguish a global variable with a local variable in pl/sql?
