Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Is schema the same as database?
What is the role of the data page in the db2 database?
How do you pull up a query which was previously saved in qmf?
What is the advantage in De-normalizing tables in DB2?
What is image copy in db2?
What is ibm db2 client?
Are views updateable?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are the contents of a dclmgen?
Name the various locking levels available?
What are the benefits of using the db2 database?
What is the maximum size of a char data type in db2?
What is buffer pool?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
