Interested to Buy Any Domain ? << Click Here >> for more details...
-------------Diff b/w Union and Unionall?
- 3 Answers
- 9090 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 is the advantage of using shortcuts?
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
What are the types of security?
Define cognos report net?
what are the special features in cognos reportnet?
What are the themes in a data warehouse?
Define the cognos reporting tool?
What is Star schema group?
what are determinants?
how can you get the errors in job? when loops are araised we get error?
2. What functional area you worked on.
Teradata 
