union all allows duplicates union doesnt allows duplicates

Which one allows duplicate values Union or Union All ?

Question Posted / mahesh

Answer Posted / mahesh

union all allows duplicates
union doesnt allows duplicates

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the syntax for creating a table in the db2 database?

1093

What is a cursor in programming?

1047

What is a db2 collection?

1022

What is schema in db2?

1008

Explain the benefits you can get from mainframe connect?

958

Define buffer pool.

1034

what are bind concepts in db2 cobol?

1073

Explain db2.

1016

What is db2 connect?

1049

How to check sequence on a table in db2?

1046

What is phantom read in db2?

1136

What is catalog database in db2?

1145

What is dbrm? When it will be created?

1011

What is a db2 cursor?

1034

What is the role of the data page in the db2 database?

1011