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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is called Cognos powerplay?

821


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2200


what are the errors faced while bursting the reports and how to solve those errors?

1790


Can you explain cognos planning?

867


please please give me some banking calculations in framework manager.

1847


What is set to be Cognos configuration?

791


What is a dimension?

815


What do you understand by the term 'aggregate advisor?'

728


What are the different uses of a repository manager?

796


What is the model filter?

769


What is the advantage of using shortcuts?

849


What is a Datastore in Cognos?

1022


What are the ways to import data into catalog?

836


What do you mean by drill across?

825


Give me any example of semi and non additive measures?

734