Discussion :: Advanced SQL - General Questions (Q.No.2)
What type of join is needed when you wish to return rows that do have matching values?
Answer: Option D
No answer description available for this question.
|Rajkumar said: (Apr 6, 2011)|
|Non equi-join is return rows that do have matching values.|
|Sapna said: (Dec 23, 2011)|
|Yes the right answer is equi join.|
|Ranga said: (Dec 29, 2011)|
|Equi join is correct|
|Rishabh said: (Aug 19, 2012)|
|Equi-join both side same value then you used simple join.|
|Kala said: (Dec 16, 2013)|
|Equi join is correct. Outer join gives non matching values. Equi join gives matching values.|
|Hema said: (Jan 8, 2014)|
|Equi join is the correct one for match values.|
|Amol said: (Aug 19, 2014)|
|"all of the above" is correct answer because. Outer join returns the row having matching as well as non matching values.|
|Habtamu said: (Nov 19, 2014)|
From the 4 choice which one is more answerable?
|Binay said: (Dec 16, 2014)|
|Can you explain in detail?|
|Pachi said: (Sep 25, 2016)|
|Yes, option D is right one. Because also outer join return matching rows from both tables.|
|Alelign said: (Dec 31, 2016)|
|Yes, the correct answer is D because outer join returns both values that have the same and different values.|
|Sakhile said: (Aug 24, 2018)|
|How it should be D? Please explain the answer to me.|
|Narasimhulu said: (Dec 17, 2019)|
|The correct answer is C, Outer join returns the row having matching as well as non-matching values.|
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.