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
what are numeric data types? : Sql dba
What is the difference between distinct and unique in sql?
How to get help at the sql prompt?
What is the difference between stored procedure and view?
What is a rank in sql?
What is primary key and foreign key with example?
How do you declare a variable in pl sql?
Why do we use procedures in sql?
What are different types of tables in sql?
What is a sql profiler?
What is the difference between join and natural join?
How do I run a sql trace?
What is normalization? How many normalization forms are there?
What are the three forms of normalization?
what is the difference between a local and a global temporary table? : Sql dba
