Interested to Buy Any Domain ? << Click Here >> for more details...
Which one allows duplicate values Union or Union All ?
- 3 Answers
- 7548 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 |
What is JOIN and different types of JOIN.
Name the various locking levels available?
How do you select a row using indexes in db2?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What is consistency token in db2?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
what are the bind parameters?
What is COPY PENDING status?
where can we use index and subscript ? with example ?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What are the contents of dclgen?
COBOL 
