Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to order siblings in oracle hierarchy queries?
Where the sql database files are stored?
What is a relationship and what are they?
tell us something about heap tables. : Sql dba
how to increment dates by 1 in mysql? : Sql dba
How delete a row in sql?
How do you take the union of two tables in sql?
How do I save the results of sql query in a file?
What is pl sql script?
What is the difference between left outer join and left join?
What is varchar example?
What is the purpose of using pl/sql?
How to display Row Number with Records in Oracle SQL Plus?
How to load data with sql*loader?
What problem one might face while writing log information to a data-base table in pl/sql?
