Answer / nashiinformaticssolutions

• 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;

Answer / 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;

Answer / 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;

display null value rows with out using null function?

8 Answers   Infosys,

---

What is Difference Between delete and Truncate?

9 Answers  

---

what is commit? : Sql dba

0 Answers  

---

What is scalar data type in pl sql?

0 Answers  

---

Explain how exception handling is done in advance pl/sql?

0 Answers  

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

What is a clob in sql?

0 Answers  

---

what is user defined functions? : Sql dba

0 Answers  

---

What is the importance of sqlcode and sqlerrm?

0 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

why we use nocopy?

2 Answers   Polaris,

---

How do you retrieve the second highest salary from a table?

3 Answers  

---