what is the difference between join and union?
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
How to retrieve rows from a db2 table in embedded sql?
What is cobol db2?
How to connect to db2 database from windows command line?
How can deadlocks be resolved?
How to rename a table in DB2 ?
Explain the function of data manager.
What is runstats db2?
Explain packages.
What is load utility in db2?
What is coalesce in db2?
What is cloudant database?
Explain about open switch business continuity software?
What is db2 command?
What is the difference between using bind () and rebind () methods of naming class?
What is the use of db2?