Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
- 1 Answers
- 1217 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
• 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 |
Post New Answer View All Answers
What is the difference between view and materialized view in Oracle?
Why is oracle used?
How to filter out duplications in the returning rows using oracle?
Explain the use of full option in exp command.
What is the sid in oracle?
What happens to the indexes if a table is recovered?
What is integrity and what is constraint??Explain with example
What is a nested table and how is it different from a normal table?
How do I learn what codesets are available in oracle?
What is a parameter file in oracle?
What does sharding mean?
Explain temporal data types in oracle
what is IDE,DMV in sql server?
How to manage transaction isolation level?
Explain the use of control file?
