Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is the difference between join and union?

Answers were Sorted based on User's Feedback



what is the difference between join and union?..

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

what is the difference between join and union?..

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

what is the difference between join and union?..

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

what is the difference between join and union?..

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

Post New Answer

More DB2 Interview Questions

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).

10 Answers   Cap Gemini, Wipro,


What are packages in db2?

0 Answers  


What is cursor in dbms?

0 Answers  


What is ALTER ?

3 Answers  


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

2 Answers  


Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,


What does the RUNSTATS Utility do?

4 Answers  


Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  


What is drop table?

0 Answers  


How does DB2 determine what lock-size to use?

2 Answers  


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

2 Answers  


Categories