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
- 7495 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / naidu sekhar yandrapu
SELECT SSN FROM B;
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is dbrm? What it contains? When it will be created?
How does a cursor work?
How do I copy a table in db2?
What is image copy in db2?
What is explain in db2?
Give the name of some fields form sqlca.
How to rename a table in DB2 ?
Which components manage deadlocks in db2?
Is db2 relational database?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
How can you quickly find out the # of rows updated after an update statement?
What is the purpose of rollback and commit?
What is the difference between cursor stability and repeatable read isolation levels?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is db2 plan table?
