Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between join and union?
- 4 Answers
- 18981 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suresh ramaiyan
Join is used retrive the data from two or more tables.
Union is used to join the result of two queries.
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / lokesh chauhan
Join is used to established a conditional selection from 2
different tables, while union is used to select similar
data based on different conditions.
| Is This Answer Correct ? | 7 Yes | 6 No |
Answer / ananda kumar
join retrive the data more than one table using single sql
query where as union combine the results of two or more sql
queries.
| Is This Answer Correct ? | 2 Yes | 2 No |
Which component is responsible for processing sql statements and selecting access paths?
Outputs of explain are with matchcols = 0. What does this signify?
How would one remove old reorg information from the DB2 catalog?
What is meant by AUTO COMMIT?
Which component is used to execute the sql statements?
What is the role of data manager in the db2 database?
What is dynamic SQL?
what is sql abend code -801,-802?
What is buffrpool? Where we use it ?
What is a subselect? Is it different from a nested select?
What is the command used by TSO users to invoke DB2?
My SQL is not performing well. Describe how will you fine tune it?
COBOL 
