-------------Diff b/w Union and Unionall?
- 3 Answers
- 8533 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / the_xxx
The main difference between UNION ALL and UNION is UNION
only selects distinct values, UNION ALL selects all values
(including duplicates).
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / abd hfz
UNION gives result set of only distinct values from both
tables where as UNION ALL selects all values including
duplicates.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sridevi
UNION will give only distinct values where as UNION ALL gives all the values including duplicates.Performance wise UNION ALL is faster than UNION because UNION needs to exclude duplicates.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are initial page components of Cognos connection?
What is main advantage datawarehousing over oracle?
what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?
what are the special features in cognos reportnet?
Can u solve a small query on table the problem is whether it is possible to add extra cells for already existed table i.e if table contains 3 rows n 4 cols (3*4) it is possible to add another cell (4*4)
what is report burn and where it occurs
What are types of batch available in cognos?
hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....
what is mean by cognos powerhouse?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
What is cognos powerhouse?
What do you understand by the term 'dynamic cube'?
Teradata 
