what is the difference between union and union all
- 14 Answers
- 43877 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 bond code in materialized view?
What is sql injection owasp?
What is procedure explain with example?
What is on delete restrict?
What steps server process has to take to execute an update statement?
Which is better join or subquery?
What are aggregate and scalar functions?
Does inner join remove duplicates?
What are the advantages of pl sql?
What is difference between cursor and trigger?
Does sql view stored data?
how to install mysql? : Sql dba
Difference between table function and pipelined function?
what is an extent ? : Sql dba
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
