Database - Advanced SQL - Discussion
Discussion Forum : Advanced SQL - General Questions (Q.No. 2)
2.
What type of join is needed when you wish to return rows that do have matching values?
Discussion:
13 comments Page 1 of 2.
Rajkumar said:
1 decade ago
Non equi-join is return rows that do have matching values.
Sapna said:
1 decade ago
Yes the right answer is equi join.
Ranga said:
1 decade ago
Equi join is correct
Rishabh said:
1 decade ago
Equi-join both side same value then you used simple join.
Kala said:
1 decade ago
Equi join is correct. Outer join gives non matching values. Equi join gives matching values.
Hema said:
1 decade ago
Equi join is the correct one for match values.
Amol said:
1 decade ago
"all of the above" is correct answer because. Outer join returns the row having matching as well as non matching values.
Habtamu said:
1 decade ago
@Amol
From the 4 choice which one is more answerable?
From the 4 choice which one is more answerable?
Binay said:
1 decade ago
Can you explain in detail?
Pachi said:
9 years ago
Yes, option D is right one. Because also outer join return matching rows from both tables.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers