Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between join and union?
- 4 Answers
- 18807 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 |
How can we read records for specific member in CL? AND rpg?
How and when does the db2 enforces the unique key?
How to resolve -803 sql code in DB2?
How do I optimize a query in db2?
What is auditing?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
How to restart a DB2 program?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
How to create backup table in db2?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
COBOL 
