What is difference between Union and Union All ?
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
Compare microstrategy and tableau.
What do you mean by inmon?
What is microstrategy intelligence server?
Explain security filter?
Can reports be executed in off-peak periods?
What is the difference between absolute filtering and standard filtering in microstrategy?
Explain true primary keys?
What is fact degradation?
you are required to disable webusers to use only one i-server. How would you do that?
Explain confirmed dimensions. When are they used?
Write the different types of matrices in microstrategy?
What is a joint child?
What are objects?
How do users receive only information that they want?
Explain fact relation?