SELECT SSN FROM B;

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?

Question Posted / naidu sekhar yandrapu

3 Answers
8670 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

Please Help Members By Posting Answers For Below Questions

Define sqlca.

1056

How do we specify index to include or not during bind process.

2072

Explain about rct in db2?

1046

What is a dbrm in db2?

971

What is the difference between dbm cfg and db cfg file in db2 ?

1481

What is meant by dclgen?

1061

How many types of page locks can be held in db2?

996

What is db2 purescale?

945

Mention some fields that are a part of sqlca.

972

What is the meaning concurrency in the db2 database?

1061

Can we insert update delete in view?

912

How can you quickly find out the # of rows updated after an update statement?

987

What is the physical storage length of date data type?

1191

How can the duplicate values be eliminated from db2 select?

1044

Discuss about db2 bind?

1052