SQL Joins Interview Questions and answers | most common joins in SQL interview Questions

In this video you will learn most common SQL Joins interview questions and answers. Such as

Joins in SQL Interview Questions

1. What is Join in SQL?
2. Types of joins?
3. What is inner join?

Ex:
Select e.Employee_name,b.Department_name
where e.Department_ID=b.Department_ID;

4. What is outer join?
5. Explain Left Outer Join with Example
Syntax :

Ex:
Select a.Employee_name,b.Department_Name from Employee a left outer join Department b on.Department_ID=b.Department_ID;
6. Explain right outer join with example?

Syntax:

Example:
Select b.Department_Name,a.Employee_name from Employee a right outer join Department b on.Department_ID=b.Department_ID;

7. What is difference between joins and union?


8. Why SQL Joins?

9. What is full outer joins?
10. What is self join?

Real Example:

The self join is used to find out the employee and his manager name in same employee table.

11. What is equi join?

Example :

Select e.Employee_name,b.Department_name from Employee e,Employee b where a.Department_ID=b.Department_ID;

[naveenandhavarapu]

so what is the difference between outer join and full outer join and
equi join and inner join