What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
- 1 Answers
- 1367 Views
- I also Faced
- E-Mail Answers
• INNER JOIN: Returns only matching rows from both tables.
• LEFT JOIN: Returns all rows from the left table and matching rows from the right.
• RIGHT JOIN: Returns all rows from the right table and matching rows from the left.
• FULL JOIN: Returns all rows from both tables, filling in missing values with NULLs.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an Oracle Instance?
How to start your 10g xe server?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
How to establish administrator authentication to the server?
Explain the use of rows option in exp command.
What is a cluster Key ?
What is oracle thin client?
How to change system global area (sga) in oracle?
What happens if the imported table already exists?
What are cursor?where are they used?
write a query that displays every Friday in a year with date?
What is the quickest way to export a table to a flat file?
Oracle General 
