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

Name the lockable units in DB2?

1086

What is db2 command?

984

What is commit in db2?

1004

What is check constraint in db2?

1027

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1051

What do you mean by storage group (stogroup)?

1000

What is dpf in db2?

1062

What is alias in db2?

1008

What is the clustering index in the db2 database?

966

How connect db2 database to datastage?

1198

what is the sqlcode -501

12964

How do you stop a db2 database in linux?

970

Explain package in db2 and its advantages?

1158

Is db2 a mainframe?

994

What is coalesce in db2?

1072