Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Union and Union All ?
- 1 Answers
- 3464 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / sagar
1) By union ALL u will get duplicate records also(the records common between 2 tables 2 times) but Union gives u union of 2 tables
2) 'Union All' is faster than Union
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Your application mode has crashed. How would you get the instance back?
What happens if the owner of an object does not exist in the destination project?
If your client wanted to customize the null value, how would you do that?
Explain snowflake schema?
Explain level extension?
What is the conflict resolution window?
Explain fact table?
What are the vldb properties? Which level of vldb configurations have the highest precedence?
What are the different modes to run i-server?
Can you explain surrogate key?
How conflicts occur and what are the ways to resolve them?
what do you mean by passthrough functions?
How we can decided drilling options for an attribute?
How is security handled?
Explain fact?
