Answer Posted / hr@tgksolutions.com
• 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
What is the difference among union, minus and intersect?
What is the starting oracle error number?
What is a clob in sql?
What is sql analyzer?
What is a trigger word?
how to use myisamchk to check or repair myisam tables? : Sql dba
How to convert comma separated string to array in pl/sql?
What is the best free sql database?
What is data manipulation language?
What is rollback?
Does view contain data?
Are stored procedures faster than queries?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is set transaction?
What is sql lookup?
