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;

What are data types in pl sql?

1146

---

What is nvarchar max in sql?

1021

---

Why join is faster than subquery?

1117

---

What is procedure explain with program?

1023

---

How do you know if a relationship is 2nf?

946

---

what is foreign key? : Sql dba

1058

---

What is the file extension for sql database?

1006

---

Is sql pronounced sequel or sql?

1273

---

What is record variable?

997

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

---

Enlist the data types that can be used in pl/sql?

1073

---

How do I turn a list into a table?

963

---

how to include comments in sql statements? : Sql dba

962

---

How do I run a sql script?

1152

---

what is rollback? : Sql dba

1115

---