Interested to Buy Any Domain ? << Click Here >> for more details...
Explain an outer join?
- 1 Answers
- 5056 Views
- I also Faced
- E-Mail Answers
Answer / vamsikrishnamraju
An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained
| Is This Answer Correct ? | 2 Yes | 0 No |
Which components manage deadlocks in db2?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
What is DCLGEN ?
What is dbrm?
What are the three DB2 date and time data types and their associated functions?
What does DML stand for and what are some examples of it?
What is the difference between cursor stability and repeatable read isolation levels?
Which catalog table stores referential constraints?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
How does a cursor work?
Describe what a storage group(STOGROUP) is?
COBOL 
