Interested to Buy Any Domain ? << Click Here >> for more details...
Which one allows duplicate values Union or Union All ?
- 3 Answers
- 7644 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahesh
union all allows duplicates
union doesnt allows duplicates
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / surendra reddy
union does not allow duplicates
union all allowed duplicate values
| Is This Answer Correct ? | 1 Yes | 0 No |
How will you return the number of records in table?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
How do you insert a record with a nullable column?
What is ibm db2 connect?
How to get the ddl of a table in db2?
What do you mean by cursor?
What is the difference between bind and rebind in db2?
What is the STOSPACE Utility used for?
where will u check for sqlcode ?
Before you give the explain statement, what are the prerogatives?
What is page size in db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
COBOL 
