what is the difference between join and union?
- 4 Answers
- 17020 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 |
What is the use of db2 optimizer?
How to handle null values in db2
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How do you retrieve the data from a nullable column?
How are write I/Os from the buffer pool executed?
What does the RUNSTATS Utility do?
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language
What are the 2 sqlcodes that are returned?
What is the physical storage length of the data types date, time, and timestamp?
What is the difference between group by and order by?
How many clustering indexes can be defined for a table?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
COBOL 
