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
How does a covering index work?
what are dynamic queries in t-sql? : Transact sql
What is pl sql commands?
How many developers work on postgresql?
What is pl sql block in dbms?
What is range partitioning?
Can sql function call stored procedure?
What does := mean in pl sql?
How is data stored in sql?
What is a data definition language?
how can we know the number of days between two given dates using mysql? : Sql dba
How to look at the current sql*plus system settings?
Explain the working of primary key?
What is the difference between local variables and global variables?
Explain the components of sql?
