Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between join and union?
- 4 Answers
- 18644 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's the error code for Unique Index Violation?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
Which transaction use a command thread ?
how do u update the faltfile into db2 table ?
What is catalog database in db2?
What is data manager?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
what is the difference between declaring the cursor in WS section and Procedure division?
what is the difference between where clause and having clause
What should be specified along with a cursor in order to continue updating process after commit?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is DCLGEN?
COBOL 
