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 |
How do you filter out the rows retrieved from a Db2 table ?
What does a deadlock mean in DB2?
what is rebinding ?
What information can you find in SYSIBM.SYSLINKS table?
where will u check for sqlcode ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What kind of database is db2?
What is a page?
What are the disadvantages of using VARCHAR?
what is dynamic cursor?gives syntax for this?
Can we install 2 different versions of Db2 on same mainframe?
what is the difference between where clause and having clause