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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

WHAT ARE THE DISTNICT VARIABLES?

1753


How the Bursting happens in same report and how to Print the bursting Report?

1444


hi friends pls forward impropmtu interview question

1687


What is defined as data mining?

603


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1487






What do you mean by drill through report?

579


What is meant by Reportstudio shortcut?

1729


------------ Diff b/w MemberCaption and MemberDescription?

1908


What is a Framework manager?

561


Which lifecycle we will use for reporting?

565


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 ?

1559


How can I schedule reports in cognos?

598


What are all the components of Report Studio?

667


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10749


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

557