What techniques are used to retrieve data from more than one table in a single

What techniques are used to retrieve data from more than
one table in a single SQL statement?

Question Posted / guest

2 Answers
6509 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What techniques are used to retrieve data from more than one table in a single SQL statement?..

Answer / obu

JOIN Statement

Is This Answer Correct ?

6 Yes

0 No

What techniques are used to retrieve data from more than one table in a single SQL statement?..

Answer / ezaz

joing

Is This Answer Correct ?

0 Yes

4 No

Post New Answer

More DB2 Interview Questions

How do I add a column in db2?

0 Answers

what is parm utility

2 Answers IBM,

What is release/acquire in bind?

0 Answers

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers HCL,

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers Wipro,

When do you use the IMAGECOPY?

4 Answers

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers

How would one remove old reorg information from the DB2 catalog?

2 Answers

What is a db2 tablespace?

0 Answers

What is cursor stability?

1 Answers

How to view db2 table structure?

0 Answers

For more DB2 Interview Questions Click Here