What is difference between Union and Union All ?
- 1 Answers
- 2552 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 |
how do you create schema objects in 2 tier connection?
Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?
What is purpose of having conditionality in metrics in microstrategy?
How to use value prompt and drag it on to report editor
can metadata be manually edited? If yes, how?
How we can create the Intelligent cubes in Microstrategy?
What is smart metric?
Difference between project merge and object manager?
What do you mean by inmon?
Explain snowflake schema?
what are the different authentication modes available in microstrategy?
What are report caches and how many types are there?
Teradata 
