What is JOIN and different types of JOIN.

Question Posted / guest

Answers were Sorted based on User's Feedback

What is JOIN and different types of JOIN...

Answer / nidhi sharma

joining of data from two different table by coloums
inner join
outer join
a.left outer join
b.right outer join
c.full outer join

Is This Answer Correct ?

26 Yes

1 No

What is JOIN and different types of JOIN...

Answer / vamsikrishnamraju

Sometimes we have to select data from two or more tables to
make our result complete.
inner join
left join
right join

Is This Answer Correct ?

7 Yes

4 No

More DB2 Interview Questions

What is the picture clause of the null indicator variable?

What is a trigger in the db2 database?

What is the difference between spufi and qmf?

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

What is reorg in DB2

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

What are the three types of page locks that can be held?

What r the comman abends in db2, jcl and cobol???????

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

What are the various locks available?

For more DB2 Interview Questions Click Here