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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to retrieve rows from a db2 table in embedded sql?

1394


What is cobol db2?

1003


How to connect to db2 database from windows command line?

1066


How can deadlocks be resolved?

938


How to rename a table in DB2 ?

1089


Explain the function of data manager.

1047


What is runstats db2?

1037


Explain packages.

1114


What is load utility in db2?

1181


What is coalesce in db2?

1136


What is cloudant database?

1101


Explain about open switch business continuity software?

1136


What is db2 command?

1040


What is the difference between using bind () and rebind () methods of naming class?

1401


What is the use of db2?

1057