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 microstrategy intelligence server?
What are the different types of mstr objects?
What are objects?
What is embedded metric?
If your client wanted to customize the null value, how would you do that?
Explain 4gt switch?
what is a security filter?
What is an i-server?
Intelligent cube is a public object or schema object in microstrategy?
Explain factless facts?
Can the administrator easily maintain and manage microstrategy intelligence server?
what specific features and functionality do you get with olap services?