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

I have two tables A and B. Both tables are connected with SSN
number as foreign key. I want to retrieve a column data from B
table. How will you write a query?

Question Posted / shaikdada

Answers were Sorted based on User's Feedback



I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to ret..

Answer / harsha

One can use Inner Join to get data from two tables.

Is This Answer Correct ?    4 Yes 1 No

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to ret..

Answer / siri

1)select ssn from b;
2)select b1.ssn from a a1,b b1 where a1.ssn=b1.ssn
3)seelct b1.ssn from a a inner join b b1 on a1.ssn=b1.ssn

Is This Answer Correct ?    0 Yes 1 No

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to ret..

Answer / naidu sekhar yandrapu

SELECT SSN FROM B;

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More DB2 Interview Questions

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

What does an outer join do?

1 Answers   CTS,

can i code union in cobol-db2 pgm ?

4 Answers   Patni,

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

What is the difference between drop table and delete table?

0 Answers  

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

What are the various isolation levels possible?

0 Answers  

What is phantom read in db2?

0 Answers  

Explain about open switch business continuity software?

0 Answers  

Name the different types of Table spaces.

5 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories