What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
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
Where is the export dump file located?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is object data modeling?
what's query optimization and without use of IN AND Exist can we get another way data from query
Explain what are the different type of segments?
Difference between open_form and call_form in oracle.
What is ADDM Advisor in Oracle?
What is a tns file?
When do you get a .pll extension in oracle? Explain its importance
how to handle exceptions in post production
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to change user password in oracle?
How to export your connection information to a file?
How can I see all tables in oracle?
What is connection pool in oracle?