What is an inner join, and an outer join ?
Answer / s
Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.
Is This Answer Correct ? | 27 Yes | 2 No |
What is difference between isnull and coalesce?
How will fetch last 5 rows from table in db2
What is the meaning concurrency in the db2 database?
cursor with hold explain ?
How can we retrieve the total number of records in RPG & CLLE?
Is db2 a database?
What is a db2 schema?
Once you create a view, where would information about the view be stored?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What will happen, while trying to close the closed cursor.
What are the three lock types?
How do I delete a table in db2?