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

What is the current version of postgresql?

1056

---

Can a view be mutating? If yes, then how?

1021

---

Is sql a oracle?

970

---

Is left join faster than join?

1045

---

Which table is left in left join?

1007

---

What does varchar include?

943

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4269

---

Why do we create views in sql?

1146

---

Is sql a programming?

970

---

what are the differences between binary and varbinary? : Sql dba

1036

---

Show the cursor attributes of pl/sql.

1043

---

What is auto increment in sql?

1113

---

What is sql clause?

1043

---

What is the difference between function, procedure and package in pl/sql?

1242

---

How do I run a script in sql developer?

943

---