union does not allow duplicates union all allowed duplicate values

Which one allows duplicate values Union or Union All ?

Question Posted / surendra reddy

3 Answers
7540 Views
I also Faced
E-Mail Answers

Answer Posted / surendra reddy

union does not allow duplicates

union all allowed duplicate values

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2727

What is ibm db2 database?

1008

What is collection in db2 bind?

1017

How to find the number of rows in a db2 table?

1120

Define db2 and its databases?

1057

How do I start db2 in windows?

1096

How does cobol compile db2 program?

1063

What is the difference between dbm cfg and db cfg file in db2 ?

1539

What is netezza database?

1030

How do I create a view in db2?

1024

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4317

List some fields from sqlca?

1060

What types of tables are there in the db2 database?

1061

What is the maximum No of rows per page?

1070

Can there be more than one cursor open for any program?

1169