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;

What is lookup table in sql?

1033

---

What is crud sql?

972

---

What is serial sql?

966

---

how to drop an existing view in mysql? : Sql dba

1050

---

Is big data nosql?

935

---

How to disable a trigger name update_salary?

1258

---

What is clustered and nonclustered index in sql?

935

---

What are all the common sql functions?

1007

---

Explain spool.

1172

---

How do I sort a table in sql?

1025

---

What is recursive join in sql?

1001

---

Which query operators in sql is used for pattern matching?

952

---

What is data profiling in sql?

1065

---

what is text? : Sql dba

1065

---

What are the built in functions of sql?

1024

---