Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between join and union?
- 4 Answers
- 18653 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 |
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What are packages in db2?
What is cursor in dbms?
What is ALTER ?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
Why use RUNSTAT Utility?
What technique is used to retrieve data from more than one table in a single SQL statement?
What does the RUNSTATS Utility do?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is drop table?
How does DB2 determine what lock-size to use?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
COBOL 
