Given sample data on two tables, write down the result sets of all types 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

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

Top BNP Paribas SQL Developer interview questions & answers

Popular interview questions of SQL Developer

Top HR questions asked in BNP Paribas SQL Developer