The main difference between UNION ALL and UNION is UNION only selects dist

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

Question Posted / the_xxx

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

Please Help Members By Posting Answers For Below Questions

i have one file i saved in csv how can i take these file into framework manager

2122

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

2088

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3600

Can you define bitmap index?

1118

What you mean by drill across and what is the difference between drill through, drill across?

1078

Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3666

What are the different kinds of panes included in cognos?

1104

what is the main advantage of impromptu over cognos reportnet?

1086

What you mean by drill across?

1067

what are the filters in framework manager and report studio?

1038

Define the cognos reporting tool?

1095

What are all the components of Report Studio?

1149

Can you define report item?

1095

What is the function of cognos dispatcher?

1265

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1128