What is difference between Union and Union All ?
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 |
Your account is locked and your administrator has forgotten the password. What would you do?
Compare dataset and fileset?
What is an i-server?
How to do performance tuning on reports.
Which of the end-user items leverage olap services?
what are the nulls on microstrategy report and how to mask them.
What are objects?
Is it possible to apply themes to microstrategy web? How?
Explain 4gt switch?
What are the supported languages for microstrategy intelligence server?
What is an object prompt?
What leads to a cross-join or how does a cross-join occur?