-------------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

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1560


can we insert all types of charts in a list report? what r the realtime prompts?

1673


Can you define fan trap?

753


How to publish a package by running Java Script?

1602


What are the steps to import the two data sources in framework manager?

616






how to connect datamarts

2376


how to merge 2 crosstabs thans

2159


What are various types of gateways in cognos?

545


What do you understand by the term 'model durability'?

570


Explain what is the main advantage of impromptu over cognos reportnet?

603


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2143


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1757


What is the use of powerhouse?

614


What is the report studio?

602


write a query to display the departments with no employee?

1553