What is JOIN and different types of JOIN.
Answers were Sorted based on User's Feedback
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 |
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 |
Explain about dbrm.
Describe major components of db2?
where can we use index and subscript ? with example ?
How do you prepare a COBOL + DB2 program from coading till execution ?
What techniques are used to retrieve data from more than one table in a single SQL statement?
what are the bind parameters?
On which levels locks can be applied?
what is a corelated subquerry?
What is the STOSPACE Utility used for?
What is SPUFI?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?