What is difference between Union and Union All ?
- 1 Answers
- 2574 Views
- L&T, I also Faced
- E-Mail Answers
Answer / 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 |
What are configuration objects?
What are report caches and how many types are there?
Can microstrategy desktop access operational data systems?
Explain 4gt switch. Does it have any drawback?
Write the different types of matrices in microstrategy?
What are the types of facts in microstrategy?
Your i-sever crashed. What will you do?
What do you mean by trimming sql in microstrategy?
What is static prompt in microstrategy?
What is the difference in the way microstrategy handles custom group and consolidations?
Write the components microstrategy metadata?
What is heterogeneous mapping?
Teradata 
