Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between join and union?
- 4 Answers
- 18773 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s
Join returns only rows that are qualified based on the Join
predicate. Whereas UNION retrieves both result sets above
and below the UNION operator and sorts to remove duplicates
before it returns the First row to the pgm
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
What is commit in db2?
can all users have the privilage to use the sql statement select * (dml)?
Define check constraint.
Give the name of some fields form sqlca.
What is the information associated with sysibm.syslinks table?
Why do we use cursor?
What is ibm db2 used for?
How would you find out the total number of rows in a db2 table?
What is the difference between db2 and oracle?
What is a db2 cursor?
What are the bind parameters ibm db2?
What is the use of value function?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the difference between drop table and delete table?
What is node in db2?
