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?
- 3 Answers
- 8105 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsha
One can use Inner Join to get data from two tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
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 |
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
Describe major components of db2?
When do you use the IMAGECOPY?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is UNION,UNION ALL?
Name the lockable units in DB2?
What is cursor stability in db2?
What is innodb buffer pool?
Is db2 free?
What is a synonym ?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is a DB2 catalog?
COBOL 
