Database - Advanced SQL - Discussion

Discussion :: Advanced SQL - General Questions (Q.No.1)

1. 

What type of join is needed when you wish to include rows that do not have matching values?

[A]. Equi-join
[B]. Natural join
[C]. Outer join
[D]. All of the above.

Answer: Option C

Explanation:

No answer description available for this question.

Ranjeeth Raj R said: (Mar 20, 2011)  
OUTER JOIN is the only joins which shows the unmatched rows

Vipul Javeri said: (Apr 20, 2011)  
If you want unmatched rows you will have to use an outer join.
Right outer join gives unmatched rows from right side and left outer join gives unmatched rows from left side.
Full outer join (supported from oracle 9i onwards) will include unmatched rows from both sides.

Narinder Kehar said: (May 19, 2011)  
Outer join can be used because it provide right and left unmatched rows.

Nibash Panddey said: (Feb 27, 2012)  
If you want unmatched rows you will have to use an outer join.

Right outer join gives unmatched rows from right side and left outer join gives unmatched rows from left side.

Full outer join (supported from oracle 9i onwards) will include unmatched rows from both sides.

Gganju said: (May 4, 2013)  
Full Join: Retrieve all records from tables on both sides of the join condition regardless of whether records match the join criteria.

Niraj Kumar said: (Mar 4, 2014)  
OUTER JOIN is the only joins which shows the unmatched rows.

Sweety said: (Aug 5, 2016)  
How outer join? explain me in detail.

Pranjli said: (Sep 12, 2016)  
Outer join shows the result of right outer join in which table of RHS is comparing with the LHS.

Sabina said: (Feb 7, 2017)  
Why not Equi-join?

Amit Ranjan said: (Mar 16, 2018)  
Out join will provide the unmatched rows of left and right table.

Niranjan K C said: (Jan 24, 2019)  
Outer join is a combination of left and right outer join so we can retrive the unmatched records, by using suitable left or right outer join.

Upendra said: (Apr 8, 2020)  
The equijoin applied to two tables if both table have on common column.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.