Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between union and union all
- 14 Answers
- 45983 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 are % type and % rowtype?
Why we use cross join?
what are all the different types of indexes? : Sql dba
How do you declare a variable in pl sql?
What is the difference between null value, zero, and blank space?
What are properties of the transaction?
What is a schema sql?
What is the unique index?
how to rename an existing column in a table? : Sql dba
What are all the different types of indexes?
what are the types of subquery? : Sql dba
What is blind sql injection?
What trigger means?
What is trigger in sql? Explain
How to use distinct and count in sql query? Explain
