What is difference between Union and Union All ?

Question Posted / sagar

1 Answers
3410 Views
L&T, I also Faced
E-Mail Answers

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

Post New Answer

More Micro Strategy Interview Questions

What are objects?

0 Answers

What is level prompt?

0 Answers

Explain rw document?

0 Answers

What subtotaling features does microstrategy desktop contain?

0 Answers

What is microstrategy intelligence server?

0 Answers

In Microstrategy, how can you direct the sql generated to use a specifc table?

7 Answers Lanco,

how can we direct the sql generated to use a specifc table?

0 Answers

Explain 4gt switch. Does it have any drawback?

0 Answers

What is an i-server? What are the different modes to run it?

0 Answers

I am in chennai.I need Micro strategy ,Informatca & BO cd (not orginal)Please where get that.I really this badly. Regards, Raji

1 Answers

What is heterogeneous mapping?

0 Answers

Is it possible to get a floating window in microstartegy web? If yes, how?

0 Answers

For more Micro Strategy Interview Questions Click Here