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

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

define clustering index.

0 Answers  


Define data page.

0 Answers  


What is bind in db2?

0 Answers  


How connect db2 database to datastage?

0 Answers  


What is difference between alias and synonym in db2?

0 Answers  






List down the types of triggers in the db2 database?

0 Answers  


Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  


Is there any advantage to denormalizing DB2 tables?

1 Answers  


Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  


Which isolation level provides maximum concurrency?

0 Answers  


Define declaration generator (dclgen).

0 Answers  


What is a cursor in programming?

0 Answers  


Categories