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

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

More DB2 Interview Questions

What is meant by isolation level?

What's the difference between DB2 active log and archive log? Thanks a lot...

Outputs of explain are with matchcols = 0. What does this signify?

what is difference between Plan and Package

What is pagespace?

How many databases are there?

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

Is db2 relational database?

When DB2 connection fails, will online program work or give errors.

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

For more DB2 Interview Questions Click Here