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?
Answer Posted / naidu sekhar yandrapu
SELECT SSN FROM B;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What happens in bind step in a db2 program?
How can you find out the # of rows updated after an update statement?
How do I add a column to a table in db2?
How can record locking be achieved in those DB2 versions which do not support it?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is cobol db2?
What is dbrm?
What is runstats utility in db2?
What is a db2 schema?
can all users have the privilage to use the sql statement select * (dml)?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the syntax for FETCH in DB2 ?
Explain package in db2 and its advantages?
What do you mean by rollback?