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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

what is the difference between join and union?

Question Posted / guest

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

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

Can you use max on a char column?

0 Answers  

How will you delete duplicate records from a table?

7 Answers   Google,

Define buffer pool.

0 Answers  

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

what is load and unload in db2

1 Answers   IBM,

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  

What is blu acceleration in db2?

0 Answers  

Name some fields from SQLCA

1 Answers  

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

is it compulsory commitment control in journal?

0 Answers   TCS,

For more DB2 Interview Questions Click Here
Categories