what is the difference between union and union all
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 difference between function and trigger?
What is record data type?
What is the most common sql injection tool?
What is sql profiler in oracle?
What is a schema sql?
What is a unique key and primary key and foreign key?
How do I make sql search faster?
What is difference between sql and excel?
what are the types of join and explain each? : Sql dba
What is primary key in db?
How many types of cursors are available in pl/sql?
define sql insert statement ? : Sql dba
What is sql injection vulnerability?
What is trigger explain it?
What are the main features of cursor?