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

Question Posted / arkchowdary

3 Answers
9251 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

What is defined as catalog and types of catalogs in Cognos?

0 Answers

How to publish a package by running Java Script?

0 Answers

What is the difference between filter & Condition?

3 Answers MetLife, TCS,

Please explain the different stages in creating a report in cognos report net?

0 Answers

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers

Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?

0 Answers CTS,

Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...

1 Answers

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

0 Answers Infosys,

Is there any comparison available for Cognos Reportnet Vs Crystal reports?

0 Answers IBM,

Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer

3 Answers Wipro,

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers

What is slicer & dicer ? what is sub session parameter ?

2 Answers Cap Gemini,

For more Cognos Interview Questions Click Here