Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8833 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the responsibility of the construction superintendent
What is bind plan?
What is the difference between plan and package in db2?
What is the purpose of rollback and commit?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the meaning concurrency in the db2 database?
What is image copy in db2?
Are views updateable?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Explain about open switch business continuity software?
What is load utility in db2?
When do you specify the isolation level?
What os does db2 run on?
What is ibm db2 used for?
What is a storage group (stogroup)?
