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 a sql profiler?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is pl sql collection?
How is pl sql different from sql?
Is join and inner join the same?
What are the differences between implicit and explicit cursors?
How do I clear the screen in sql plus?
What is a database trigger?
What is before and after trigger?
what are properties of a transaction? : Sql dba
Does normalization improve performance?
What mean sql?
Explain what is a subquery ?
Can variables be used in sql statements?
What is tuple in sql?
