Interested to Buy Any Domain ? << Click Here >> for more details...
-------------Diff b/w Union and Unionall?
- 3 Answers
- 9341 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 |
Please explain the different stages in creating a report in cognos report net?
what are slowly changing dimensions? Why we are used scd?
what is Cognos Visualizer?
plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?
what is conditional query subject and example
How to pass parameter value into html design page?
how to create relationship between emp and salgrade tables in frameworkmanager?
what is loop in frameworkmanager ?
After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error
What is Local Cache and how does it help in performance tuning
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
what is the difference between list sequel and cross tab sequel?
Teradata 
