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 |
What is cursor stability?
How can we read records for specific member in CL? AND rpg?
What is sqlca?
How do you Load a table ?? and what is Load replace ?
Comment whether the cursor is closed during commit or not.
How can record locking be achieved in those DB2 versions which do not support it?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
What is the physical storage length of date data type?
What will the COMMIT accomplish?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
List down the types of triggers in the db2 database?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?