Interested to Buy Any Domain ? << Click Here >> for more details...
Which one allows duplicate values Union or Union All ?
- 3 Answers
- 7485 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 do you filter out the rows retrieved from a Db2 table ?
how can you access index
What is the physical storage length of date data type?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
How to rename a table in DB2 ?
How can you compare table column after update and before update?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
how to fetch multiple records without using cursor
What are the various isolation levels possible?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
Which components manage deadlocks in db2?
COBOL 
