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;

Explian rowid, rownum? What are the psoducolumns we have?

1045

---

How do I install sql?

1043

---

What are the features of pl sql?

1107

---

What are the different types of dbms?

1060

---

how to convert numeric values to character strings? : Sql dba

1154

---

Can a foreign key be a duplicate?

958

---

Define union, minus, union all, intersect ?

1063

---

Where is pl sql used?

1002

---

What are the types of functions in sql?

1062

---

What is an alias command?

1111

---

Why truncate is faster than delete?

1157

---

Write a sql query to convert all character to uppercase after hypen.

1484

---

What is a left join?

1006

---

How to run pl sql program in mysql?

1069

---

What are synonyms in sql?

1018

---