Given sample data on two tables, write down the result sets of all types of joins.

Question

Accepted Answer

The result sets of all types of joins in SQL

Inner Join: Returns only the matching rows from both tables
Left Join: Returns all the rows from the left table and the matching rows from the right table
Right Join: Returns all the rows from the right table and the matching rows from the left table
Full Outer Join: Returns all the rows from both tables, including the unmatched rows
Cross Join: Returns the Cartesian product of both tables

Accepted Answer

Select A. Emp_no from Employee as A inner join B. Cust_no on A. Emp_no=B.cust_no

Select A. Emp_no from employee as A left join B. Cust_no on A. Emp_no=B.cust_no

Select A. Emp_no from employee as A right join B. Cust_no on A.Emp_no=B.cust_no

Select A. Emp_id as employee1, B. Emp_id as employee2 A. Emp_name from employeeA, employeeB where A. Employee_id <> B. Employee _id and A. Emp_name= B emp_name order by A. Emp_name

Asked in BNP Paribas

Given sample data on two tables, write down the result sets of all types of joins.

Top SQL Developer Interview Questions Asked at BNP Paribas

Interview Questions Asked to SQL Developer at Other Companies

Top Skill-Based Questions for BNP Paribas SQL Developer