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 |
Where can you declare a cursor in a cobol-db2 program?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
what is a plan and how do you refer the plan in the program?
Which component is used to execute the sql statements?
What is the difference between spufi and qmf?
What is a thread?
Give the COBOL definition of a VARCHAR field.
What is the usage of open cursor command?
What is reorg in DB2
Is schema the same as database?
What is normalization and what are the five normal forms?
What is PRIME TABLE and what are the uses of it