-------------Diff b/w Union and Unionall?

Question Posted / arkchowdary

3 Answers
9336 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

-------------Diff b/w Union and Unionall?..

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

-------------Diff b/w Union and Unionall?..

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

-------------Diff b/w Union and Unionall?..

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

Post New Answer

More Cognos Interview Questions

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

0 Answers

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

0 Answers IBM,

we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer

4 Answers IBM,

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers

What is a query set?

3 Answers IBM,

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers

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?

2 Answers HCL,

how to create calculate column in report studio

4 Answers

How do you test the reports? Explain the Unit testing procedures after developing the reports?

1 Answers HP, TCS,

How do we run stored procedure?

1 Answers

How to find out OLTP data OLAP data ? i.e 5 years data is OLTP or OLAP. please anybody help me...

2 Answers HCL, IBM,

Hi,Can anyone tell me training centre for cognos in Mumbai?

4 Answers

For more Cognos Interview Questions Click Here