Answer Posted / glibwaresoftsolutions
• Inner Join: Returns matching rows from both tables.
• Left Join (Left Outer Join): Returns all rows from the left table and matching rows from the right table.
• Right Join (Right Outer Join): Returns all rows from the right table and matching rows from the left table.
• Full Join (Full Outer Join): Returns all rows when there’s a match in one of the tables.
• Cross Join: Returns the Cartesian product of both tables.
• Self Join: A table joins itself.
Example Query:
SELECT e1.name, e2.name AS manager_name
FROM employees e1
JOIN employees e2 ON e1.manager_id = e2.id;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use threading in pl/sql?
What is bulk collect in pl sql?
Can we use joins in subquery?
How to add a column ‘salary’ to a table employee_details?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Is sql better than excel?
What are some emotional triggers?
What are the types of optimization?
What version is sql?
What are sql procedures?
How do I run a pl sql procedure in sql developer?
Explain character-manipulation functions?
What is mutating error?
How can check sql version from command line?
What is an implicit commit?
