Explain an outer join?
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 |
how can we find nth max salary from A table
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
how to resolve -805. give clear explination for that
What are foreign keys in db2?
Is db2 a mainframe?
Which is faster delete or truncate?
What is the difference between Primary key and unique index?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is a composite index and how does it differ from a multiple index?
What is the difference between nvl and coalesce?
How does db2 sample database connect?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)