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
- 1117 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 a cursor and what are the steps need to be taken?
How can we create the complete backup of data in the oracle.
What is materialized view in Oracle?
what is dynamic SGA and static SGA
What is recycle bin in Oracle?
How do we get field details of a table?
what is the difference between data migration and production migration.
What is difference between sid and service name in oracle?
Why do you use stored procedures and state some of its disadvantages?
State and explain about oracle instance?
what is the scripts in data base?
Does oracle partitioning improve performance?
What is a relational database management system?
How to connect ms access to oracle servers?
How to return top 5 rows in oracle?
