union all allows duplicates union doesnt allows duplicates

Which one allows duplicate values Union or Union All ?

Question Posted / mahesh

3 Answers
7539 Views
I also Faced
E-Mail Answers

Answer Posted / mahesh

union all allows duplicates
union doesnt allows duplicates

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is null value in db2?

1026

Explain correlated sub-queries.

1033

What are the contents of dclgen?

1112

What is the use of db2?

1057

How many databases are there?

1056

What is the purpose of using commit?

1100

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1160

Define buffer pool.

1059

How to execute stored procedures?

1130

What is clone table?

1046

Can you use max on a char column?

1097

List down the data types in the db2 database.

1124

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3212

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1107

Can we update view in db2?

1003