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 |
What is dynamic aggregation in microstrategy?
what is smart metrics in microstrategy?
Can microstrategy desktop access sap data?
What are vldb properties in microstrategy?
What are the different types of mstr objects?
Explain scan md?
Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?
What is derived metric?
What is level prompt?
what are the different types of tests done on a microstrategy report?
What olap capabilities do I have within a microstrategy report services document?
why consolidation and custom group not used in ic cubes. and then i will over come by derived element.. what my question is ...even (consolidation and custom group) also derived element,why we are not used. Can any body give the assistant for this issues... Regards, sekhar