What is JOIN and different types of JOIN.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2015


What is the latest version of ibm db2?

1001


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

925


Mention the various locks that are available in db2.

820


Explain how can you do the explain of a dynamic sql statement?

886


Mention some fields that are a part of sqlca.

815


Is it possible to create an Instance in DB2 using DB2 Control Center ?

878


What is clone table?

831


What is commit in db2?

836


What is the use of dclgen in db2?

828


What is cursor stability in db2?

1083


What is the difference between cursor and select statement?

889


How many databases are there?

820


What is rct?

1020


What is phantom read in db2?

860