Interested to Buy Any Domain ? << Click Here >> for more details...
Which one allows duplicate values Union or Union All ?
- 3 Answers
- 7529 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 |
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
How do you run JCL in cobol program
Mention the downsides of page level lock.
What language is db2 written in?
what is datacom db?
Which are the db2 tools to protect integrity of the database?
How do I add a column in db2?
What is a host variable?
How and when does the db2 enforces the unique key?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is copy book?
Q3. How will you fetch duplicate values from a DB2 table?
COBOL 
