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

Can we insert data into view?

850

---

how to create a new view in mysql? : Sql dba

895

---

What is the difference between cluster and non-cluster index?

1050

---

What are the different ways to optimize a sql query?

891

---

what is the difference between sql and t-sql? : Transact sql

1043

---

Why do we use partitions in sql?

979

---

what is bcp? When is it used?

1049

---

What makes a good primary key?

981

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

960

---

What does subquery mean in sql?

992

---

How can we avoid duplicating records in a query?

925

---

Which join is like an inner join?

954

---

How do I write a cron which will run a sql query and mail the results to agroup?

915

---

What are sql ddl commands?

1020

---

Why we use joins in sql?

926

---