Answer / 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;

Answer / 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;

Answer / 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;

What is delimiter sql?

0 Answers  

---

explain the difference between bool, tinyint and bit. : Sql dba

0 Answers  

---

What if we write return in procedure?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

How to avoid using cursors?

0 Answers  

---

What are different types of joins ?

5 Answers   BirlaSoft,

---

Why we use stored procedure instead of query?

0 Answers  

---

What are indexes, and what are the different types?

3 Answers  

---

What has stored procedures in sql and how we can use it?

0 Answers  

---

How do I view a sql trace file?

0 Answers  

---

What are the different set operators available in sql?

0 Answers  

---

How do sql databases work?

0 Answers  

---