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
8846 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

Why cursor is used in db2?

1036

What does sqlcabc has?

1046

What are db2 objects?

1043

What is innodb buffer pool?

1047

Can you use max on a char column?

1091

How do you pull up a query which was previously saved in qmf?

1147

What is the clustering index in the db2 database?

1000

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1100

What is bind package and plan in db2?

1051

what is a corelated subquerry?

1120

What are types of indexes?

1063

Explain correlated sub-queries.

1025

How does a cursor work?

979

What are union and union all?

976

What is the difference between plan and package in db2?

1106