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

what is the name of the default db2 catalog database?

3 Answers   IBM,


how do you resolve -805?

3 Answers   HCL,


How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  


What is db2 bind?

0 Answers  


4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,


What is database manager in db2?

0 Answers  


can we drop column from a table

7 Answers   INDUS,


How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  


Explain transactions, commits and rollbacks in DB2.

3 Answers  


How could one combine a set of incremental image copies into a single copy?

1 Answers  


How and when does the db2 enforces the unique key?

0 Answers  


What is Reorg Recovery? when will you run it?

2 Answers  


Categories