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
What is the basic structure of an sql?
what is clause? : Sql dba
How do you use join?
What are the dml statements?
how to create a table index in mysql? : Sql dba
What is delete command in sql?
What is the use of primary key?
Is sqlite free?
What is the use of non clustered index?
What is string join?
What is not in sql?
How does pl sql work?
Is drop table faster than truncate?
What is the need of a partition key?
What is the maximum number of rows in sql table?
