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
Is olap services sold as a separate product?
Which of the end-user items leverage olap services?
Does microstrategy intelligence server support scheduling?
What information is shared by the application across microstrategy web nodes?
How does microstrategy object manager determine if two projects are related?
To save time, can many reports be run at the same time?
Name the types of transformation?
How can the user determine the object id of an object?
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
Explain true primary keys?
Define different types of attributes in microstrategy desktop?
Explain security role?
What is purpose of having conditionality in metrics in microstrategy?
How would you configure wh authentication?
How would you increase the logical size of a table in microstrategy?