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
Explain the Roles in mstr?
Explain rw document?
what do you mean by passthrough functions?
How do you ensure simultaneous releases across multiple operating systems?
What is the conflict resolution window?
What is the difference in the way microstrategy handles custom group and consolidations?
What is fact extension?
You have got the requirement from a client. Explain the technical approach you will take now.
what are the criteria used by the microstrategy sql engine to build the join tree of a report’s sql?
What is derived metric?
hi,can you please share with me about,what is reportlimit,report order and how can create and use
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
Explain system call error?
Your application mode has crashed. How would you get the instance back?
Explain factless facts?