Interested to Buy Any Domain ? << Click Here >> for more details...
Explain an outer join?
- 1 Answers
- 5137 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 |
What is lock escalation in db2?
How to find the number of rows in a db2 table?
What is the difference between SYNONYM and ALIAS?
What are db2 objects?
How and when does the db2 enforces the unique key?
How to create db2 table in mainframe?
What is db2 optimizer?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is the difference between static and dynamic SQL?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
Which component is responsible for db2 startup and shutdown?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
COBOL 
