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
- 9019 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / harsha
One can use Inner Join to get data from two tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Define declaration generator (dclgen).
Mention the location where the output received from explain statement is stored.
can all users have the privilage to use the sql statement select * (dml)?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What kind of database is db2?
What are bind parameters in db2?
What is the purpose of rollback and commit?
What is dclgen (declaration generator)?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is the clustering index in the db2 database?
What is the physical storage length of timestamp data type?
What is the maximum size of varchar data type in db2?
What is the difference between using bind () and rebind () methods of naming class?
What is the maximum length of sqlca?
What type of database is db2?
