Interested to Buy Any Domain ? << Click Here >> for more details...
Which one allows duplicate values Union or Union All ?
- 3 Answers
- 7384 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 |
Can any one tell me about Restart logic in DB2.
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What do you mean by commit and rollback?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
Where is the access path logic created by the DB2 Optimizer stored?
Name the various locking levels available?
What is the difference between using bind () and rebind () methods of naming class?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
List out the buffer pools in db2
When do you use the IMAGECOPY?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
COBOL 
