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

Question Posted / arkchowdary

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

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,

Difference betwween cognos report net architecture and cognos8 architecture

3 Answers

Define olap designer?

0 Answers

Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

7 Answers IBM,

What is Cognos Powerhouse and what is it used for?

2 Answers IBM, M Care,

how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?

4 Answers

-------------------What is Deployment?

2 Answers IBM,

what is logs in cognos

1 Answers Target, Thomson Reuters,

What snowflake and Starschema?

2 Answers HCL,

why u need to publish the package?

5 Answers IBM,

Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development

11 Answers

What are the types of hierarchies?

0 Answers

For more Cognos Interview Questions Click Here