1)select ssn from b; 2)select b1.ssn from a a1,b b1 where a1.ssn=b1.ssn 3

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 / siri

3 Answers
8875 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / siri

1)select ssn from b;
2)select b1.ssn from a a1,b b1 where a1.ssn=b1.ssn
3)seelct b1.ssn from a a inner join b b1 on a1.ssn=b1.ssn

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are view updateable?

1051

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1112

Explain in brief how does db2 determine what lock-size to use?

1048

What is package in cobol db2?

1121

Which command is used to remove all rows from a table?

1119

What is db2? Explain.

1052

How to fetch the last row from the table in SQL (db2)?

1658

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.

3219

Why cursor is used in db2?

1040

On which levels locks can be applied?

1144

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1276

What is the syntax for creating a table in the db2 database?

1110

What is db2 purescale?

1012

What is host variable?

1063

How can deadlocks be resolved?

946