Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / glibwaresoftsolutions
• 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
Can we write ddl statements in functions?
What is sql procedures and functions?
Is drop table faster than truncate?
How do I count rows in sql query?
How do you remove duplicates without using distinct in sql?
Can we have two clustered index on a table?
what are all the different normalizations? : Sql dba
Why trigger is used in sql?
What is the file extension for sql database?
What is a null value?
Is it possible to create startup or shutdown trigger for on-schema?
What is difference between table and view?
What is nested table in pl sql?
What does (*) mean in sql?
What is a trigger in sql?
