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;

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1151

---

Can you rollback after commit?

966

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1060

---

What is information schema in sql?

1054

---

What is meant by temporal data?

945

---

Explain how to use transactions efficiently : transact sql

955

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1051

---

Which command is used to delete a package?

1148

---

What are the events on which a database trigger can be based?

1170

---

what is meant by nl2br()? : Sql dba

1011

---

What are the different types of functions in sql?

1037

---

How do I add a database to sql?

1110

---

What is primary key and unique key?

1099

---

How to install oracle sql developer?

1021

---

How to Declare Fixed Length String Value In PL SQL

1135

---