Interested to Buy Any Domain ? << Click Here >> for more details...
-------------Diff b/w Union and Unionall?
- 3 Answers
- 9096 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 |
I want to run one page with filter and another page without filter, what is process?
what is the use of layout calculation?
Can we create a web page where the report directory and the output can be viewed directly across cognos connection?
What you mean by drill across?
Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?
7 Answers Blue Cross Blue Shield Association, TCS,
What are the different types of important services used in cognos?
Explain the difference between native sql and cognos sql?
How many number of cubes can we create on a single model? How can we navigate between those cubes?
what is online view?
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt
what is the difference between Cognos EP7 series and Congos8?
how can you set the image in the report
Teradata 
