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;

how can we know the number of days between two given dates using mysql? : Sql dba

1041

---

How global cursor can be declare with dynamic trigger ?

2200

---

What is sequence in sql?

993

---

What is the difference between the conventional and direct path loads? : aql loader

1390

---

What is trigger in sql? Explain

981

---

What is trigger explain with example?

1024

---

What is the use of partition by in sql?

985

---

What is sql prepared statement?

976

---

Is postgresql a server?

1041

---

What is attribute indicator in pl sql?

1006

---

What are all the common sql functions?

1007

---

what are date and time intervals? : Sql dba

1049

---

What is function and procedure?

1023

---

Can we have two clustered index on a table?

1018

---

what is the difference between group by and order by in sql? : Sql dba

1113

---