Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nashiinformaticssolutions
• 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
Does sqlite need a server?
What is the life of an sql statement?
What are commit, rollback, and savepoint?
How does join work in sql?
Mention what does the hierarchical profiler does?
What is the maximum number of columns in sql table?
What are all the different normalizations?
how to check myisam tables for errors? : Sql dba
What is group function in sql?
what is the use of friend function? : Sql dba
How do I view a view in sql?
What is nosql db?
What is the current version of postgresql?
Which sorts rows in sql?
discuss about myisam key cache. : Sql dba
