Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 47071 Views
- IBM, Luxoft, Oracle, I also Faced
- E-Mail Answers
Answer Posted / soubhagya
Union:
It retrieves only distinct records.
Union all:
This retrieves duplicate records too.
but in performance issue
unioun all is better becoz it doesnot sort, filter the
record so its faster.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What does where 1 1 mean in sql?
Why truncate is used in sql?
What are different types of keys?
How to get unique records from a table?
Why do we use partitions in sql?
What is an index in sql with example?
What is numeric function sql?
what is union? : Sql dba
Explain aggregate functions are available there in sql?
How do you run a query?
How is use pl and sql?
what is the difference between primary key and unique key? : Sql dba
How do I view a procedure in sql?
What is the difference between having and a where in sql?
Why truncate is faster than delete?
