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 are iseries servers?

1130

Is db2 a database?

1027

What is image copy in db2?

1070

what is utility for parm lib

2418

What is dclgen in db2?

1195

What is sqlca?

1129

How is deadlock resolved?

1199

What does reorg do in db2?

1074

How to find the number of rows in db2 tables?

1127

Mention the different locking levels that are available in db2.

1183

what is db2 restart?

2213

What's The Percentage Free Space ?

1282

How to create db2 table in mainframe?

1217

What is the use of dclgen in db2?

1135

How to connect to db2 database from windows command line?

1134