What is difference between Union and Union All ?
- 1 Answers
- 2547 Views
- L&T, I also Faced
- E-Mail Answers
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 |
Explain attribute?
Your account is locked and your administrator has forgotten the password. What would you do?
Define different types of attributes in microstrategy desktop?
Explain confirmed dimensions. When are they used?
Is it possible to apply themes to microstrategy web? How?
What is transformation metric in microstrategy?
How can the user determine the object id of an object?
Explain oject manager?
what is microstrategy narrowcast server?
Is there a difference between view filter and report filter?
What is difference between Union and Union All ?
You have got the requirement from a client. Explain the technical approach you will take now.
Teradata 
