What is JOIN and different types of JOIN.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which components manage deadlocks in db2?

604


What types of tables are there in the db2 database?

548


How do you stop a db2 database in linux?

566


Can we insert update delete in view?

571


What is dbrm? What it contains? When it will be created?

589






Define db2 and its databases?

618


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

649


Define data page.

628


How do I delete a column in db2?

676


Describe major components of db2?

638


What is iseries database?

593


What is database reorganization?

587


define clustering index.

614


What are union and union all?

537


What are the prerogatives?

612